Greater than and Less than

Greater than (>) checks whether the value of the left field is greater than the value of the right field. If yes, then the condition becomes true. Less than (<) checks whether the value of the left field is less than the value of the right field. We can also use >/< and equals together.

For example, the following query is used to retrieve all records with login attempts more than the value 2:

SELECT * FROM `users` WHERE `login_attempts` > 2;