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