如果我运行的查询值超过列值的最大值，则获取不同的计数值

Question

Today I've encountered a new issue in MySQL.

When I've executed the following query

select `column` from table where `column` between '1' and '30000'

I've got three results

234
123
111

and when I've executed same query with different value

select `column` from table where `column` between '1' and '9000'

I've got six results

111
123
343
234
765
568

What could be the issue?

FYI : Datatype of the column is varchar.

Answer 1

The problem here is that you try to select on a text based field in a numeric way. If you would change your field to a integer field you'll get the expected results.