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