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 ? Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/196961-sql-help/#findComment-1036435 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.