如何比较高度值

Question

Hi i want know how to compare the height with other user height here is my query

select * from tbl_Member where  height between 3'8''  and 7'0'';

here height is other user height plz tell me correct query

Answer 1

I know it's dirty, but here you go

select * 
from tbl_Member 
where 
   concat(format(left(height, 1), 0), lpad(format(substr(height,3,2), 0 ), 2, '0')) 
   between 308  and 700

3'8'' becomes 308 7'12'' becomes 712