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.

Code MySQL:
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