SELECT *
FROM `view__search`
WHERE crawl_text like  "%BULB%"
OR department like  "%BULB%"
OR customerName like  "%BULB%"
OR description like  "%BULB%"
OR crawl_text like  "%BRANDS%"
OR department like  "%BRANDS%"
OR customerName like  "%BRANDS%"
OR description like  "%BRANDS%"
ORDER BY `jobID` DESC