SQL WHERE CLAUSE中的IF和ELSE

Question

I need a sql query to first check for a match WHERE column is eqaul to X1 and if no match here, search every row.

This is my current SQL statement:

SELECT name, image_url FROM `".$config_databaseTablePrefix."products` WHERE name LIKE '$queryString%' LIMIT $numberOfProducts

But I need it to check for a match WHERE e.g columnName = XX, and if no match is found look in all other rows.

How can I achieve this?

Answer 1

You can use like:

SELECT name, image_url FROM `".$config_databaseTablePrefix."products` WHERE (name LIKE '$queryString%') OR (some other rules....) LIMIT $numberOfProducts;