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