My test code for trying the behavior
The mysqli login user server behavior allows you to chose the database table you are looking up the registered user in and then in the Filter tab you can choose which column(s) to compare to which field(s) in the database before logging in. It also allows you to specify a success and failure redirect based on the result of that login.