I am fairly new to sql and am now getting into the area of slightly more
complex queries.
At present my query is
$query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type";
but I have two other filters which may or may not be chosen. (area, and
interest).
$query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%' AND
area='area' AND interest='interest' ORDER BY fname $type";
but what if nether is chosen, or only one? Is there an AND/OR operator or
similar in mysql?
Thanks,
Ross

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.