dannybrazil Posted March 30, 2010 Share Posted March 30, 2010 Hello In my database I have a field with numbers that looks like that : 1.345(x.xxx) now when I want to search something in the database how can I make it look for a specific number plus 0.005 for each direction Ex: I wanna search 1.345(so the range will be between 1.340 to 1.350) Can I do something like that:? $down=mysql_query("SELECT * FROM education WHERE num BETWEEN (num+0.005)AND(num-0.005) "); Any help ? Link to comment https://forums.phpfreaks.com/topic/196961-sql-help/ Share on other sites More sharing options...
fenway Posted April 3, 2010 Share Posted April 3, 2010 What makes you that it's not working? Link to comment https://forums.phpfreaks.com/topic/196961-sql-help/#findComment-1036435 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.