Mysql Query - Select where value could be anything
Posted on 2011-04-28
I am writing a mysql query like below:
SELECT * FROM properties WHERE price = '$price' AND type = '$type' AND tenure = '$tenure'
Some of the options allows the user to select ANY instead of selecting a specific value. So in a case when the user does select ANY how do I tell the query to select any/all results for that particular column?
I hope you know what I mean.