In the following query I would like to search for more than name
, for example: WHERE name
brand
size
LIKE ‘%q%’
but, I don’t know the correct syntax to follow.
SELECT *
FROM (
SELECT *
FROM `products`
WHERE `name`
LIKE '%q%'
AND `user_id` = '$user_id'
)
AS results
WHERE `status` = 0
OR `status` = 1
OR `status` = 2
OR `status` = 3
I need help