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