AdRock Posted September 29, 2007 Share Posted September 29, 2007 I am trying to create some search criteria and I have just written a SQL query and would like to know if it is valid SELECT * FROM table WHERE price BETWEEN min_price AND max_price, bedrooms => min_bedrooms, location = location, type = type, keyword LIKE %description% I haven't tested it becuase I have no data to test it with but the theory looks good to me Link to comment https://forums.phpfreaks.com/topic/71193-is-this-a-valid-mysql-query/ Share on other sites More sharing options...
Barand Posted September 29, 2007 Share Posted September 29, 2007 No, it isn't valid. Many years I came across a useful technique. I think the technical name for it is "experimentation". Set up some test data, because if it weren't so obviously wrong, that's what you'd be expecting us to do. Link to comment https://forums.phpfreaks.com/topic/71193-is-this-a-valid-mysql-query/#findComment-358114 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.