How to use between?

Question

MySQL

I read the docks www.mysql.ru/docs/man/Comparison_Operators.html and it was after them that the question arose

SELECT `id`,`user` FROM `table` WHERE `user` BETWEEN 1000 AND 100

It gives an empty result, although I know for sure that there is a user with a value of 500.
SELECT `user` FROM `table` BETWEEN 1000 AND 100
And if so directly, as in the docks (SELECT 'b' BETWEEN 'a' AND 'c'), then a syntax error.

Answer 1

in BETWEEN the first number is the start of the range, and the second is the end.
Your request
is similar to this:
as you can see from this condition, 500 is not more than 1000 and not less than 100, i.e. you need to create a request like this:
`user` BETWEEN 100 AND 1000