用户/通过身份验证PHP / MySQL - PHP或MySQL查询中的比较？

Question

When authenticating a user with php and MySQL, which of the following is better practice?

Method 1
MySQL Select where username and password match.
If a result comes back, user is authenticated.

Method 1
MySQL Select password where username matches.
Use php to compare passwords for successful login.

Answer 1

The first one usually, because no need to write extra code if you can do it within MySQL query, also, don't forget to make username column unique index.