How to choose which comes first when specifying OR in SELECT statement
13:33 11 Aug 2013

When you retrieve data through a MySQL statement such as the following:

SELECT * FROM course WHERE course='$product_id_array' OR course='Both' ORDER BY ...

Is there a way to output the match for 'both' first? Would this be as simple as re-arranging the order of the WHERE portion of the statement?

mysql select