mysql - Issues in working with comparison operators -

mysql - Issues in working with comparison operators -

i have sql statement looks like:

select `scaleble` `property_requirement` (`scaleble` > '850' , `scaleble` < '1200' )

and not producing results, whereas sql statement looks like:

select `scaleble` `property_requirement` (`scaleble` > 850 , `scaleble` < 1200 )

gives required results.

however, individual comparisons like:

select `scaleble` `property_requirement` (`scaleble` > '850')

and

select `scaleble` `property_requirement` (`scaleble` < '1200')

do produce required results. bit confused working of these queries. can help me this?

presumably, scalable beingness stored string. comparisons single quotes convert values strings, not numerically ordered. string '850' > '1200' nil satisfies condition.

you can prepare dropping single quotes. encourage convert value number explicitly. add together 0 purpose:

select `scaleble` `property_requirement` (`scaleble` + 0 > 850 , `scaleble` + 0 < 1200 );

mysql sql