SELECT
  *
FROM
  wp_PortalJobs
WHERE APIKey = '87B1A1B4-98EA-7DC8-2E94F3017361EF63'
  AND (
    jobOrderID = 'a b c d e f g h i j k l m n o p q r s t u v w x y z'
    OR TRIM (title) LIKE '%a%'
    AND TRIM (job_title) LIKE '%b%'
    AND TRIM (job_title) LIKE '%c%'
    AND TRIM (job_title) LIKE '%d%'
    AND TRIM (job_title) LIKE '%e%'
    AND TRIM (job_title) LIKE '%f%'
    AND TRIM (job_title) LIKE '%g%'
    AND TRIM (job_title) LIKE '%h%'
    AND TRIM (job_title) LIKE '%i%'
    AND TRIM (job_title) LIKE '%j%'
    AND TRIM (job_title) LIKE '%k%'
    AND TRIM (job_title) LIKE '%l%'
    AND TRIM (job_title) LIKE '%m%'
    AND TRIM (job_title) LIKE '%n%'
    AND TRIM (job_title) LIKE '%o%'
    AND TRIM (job_title) LIKE '%p%'
    AND TRIM (job_title) LIKE '%q%'
    AND TRIM (job_title) LIKE '%r%'
    AND TRIM (job_title) LIKE '%s%'
    AND TRIM (job_title) LIKE '%t%'
    AND TRIM (job_title) LIKE '%u%'
    AND TRIM (job_title) LIKE '%v%'
    AND TRIM (job_title) LIKE '%w%'
    AND TRIM (job_title) LIKE '%x%'
    AND TRIM (job_title) LIKE '%y%'
    AND TRIM (job_title) LIKE '%z%'
    OR TRIM (city) LIKE '%a%'
    AND TRIM (city) LIKE '%b%'
    AND TRIM (city) LIKE '%c%'
    AND TRIM (city) LIKE '%d%'
    AND TRIM (city) LIKE '%e%'
    AND TRIM (city) LIKE '%f%'
    AND TRIM (city) LIKE '%g%'
    AND TRIM (city) LIKE '%h%'
    AND TRIM (city) LIKE '%i%'
    AND TRIM (city) LIKE '%j%'
    AND TRIM (city) LIKE '%k%'
    AND TRIM (city) LIKE '%l%'
    AND TRIM (city) LIKE '%m%'
    AND TRIM (city) LIKE '%n%'
    AND TRIM (city) LIKE '%o%'
    AND TRIM (city) LIKE '%p%'
    AND TRIM (city) LIKE '%q%'
    AND TRIM (city) LIKE '%r%'
    AND TRIM (city) LIKE '%s%'
    AND TRIM (city) LIKE '%t%'
    AND TRIM (city) LIKE '%u%'
    AND TRIM (city) LIKE '%v%'
    AND TRIM (city) LIKE '%w%'
    AND TRIM (city) LIKE '%x%'
    AND TRIM (city) LIKE '%y%'
    AND TRIM (city) LIKE '%z%'
    OR TRIM (state) LIKE '%a%'
    AND TRIM (state) LIKE '%b%'
    AND TRIM (state) LIKE '%c%'
    AND TRIM (state) LIKE '%d%'
    AND TRIM (state) LIKE '%e%'
    AND TRIM (state) LIKE '%f%'
    AND TRIM (state) LIKE '%g%'
    AND TRIM (state) LIKE '%h%'
    AND TRIM (state) LIKE '%i%'
    AND TRIM (state) LIKE '%j%'
    AND TRIM (state) LIKE '%k%'
    AND TRIM (state) LIKE '%l%'
    AND TRIM (state) LIKE '%m%'
    AND TRIM (state) LIKE '%n%'
    AND TRIM (state) LIKE '%o%'
    AND TRIM (state) LIKE '%p%'
    AND TRIM (state) LIKE '%q%'
    AND TRIM (state) LIKE '%r%'
    AND TRIM (state) LIKE '%s%'
    AND TRIM (state) LIKE '%t%'
    AND TRIM (state) LIKE '%u%'
    AND TRIM (state) LIKE '%v%'
    AND TRIM (state) LIKE '%w%'
    AND TRIM (state) LIKE '%x%'
    AND TRIM (state) LIKE '%y%'
    AND TRIM (state) LIKE '%z%'
    OR TRIM (publicDescription) LIKE '%a%'
    AND TRIM (publicDescription) LIKE '%b%'
    AND TRIM (publicDescription) LIKE '%c%'
    AND TRIM (publicDescription) LIKE '%d%'
    AND TRIM (publicDescription) LIKE '%e%'
    AND TRIM (publicDescription) LIKE '%f%'
    AND TRIM (publicDescription) LIKE '%g%'
    AND TRIM (publicDescription) LIKE '%h%'
    AND TRIM (publicDescription) LIKE '%i%'
    AND TRIM (publicDescription) LIKE '%j%'
    AND TRIM (publicDescription) LIKE '%k%'
    AND TRIM (publicDescription) LIKE '%l%'
    AND TRIM (publicDescription) LIKE '%m%'
    AND TRIM (publicDescription) LIKE '%n%'
    AND TRIM (publicDescription) LIKE '%o%'
    AND TRIM (publicDescription) LIKE '%p%'
    AND TRIM (publicDescription) LIKE '%q%'
    AND TRIM (publicDescription) LIKE '%r%'
    AND TRIM (publicDescription) LIKE '%s%'
    AND TRIM (publicDescription) LIKE '%t%'
    AND TRIM (publicDescription) LIKE '%u%'
    AND TRIM (publicDescription) LIKE '%v%'
    AND TRIM (publicDescription) LIKE '%w%'
    AND TRIM (publicDescription) LIKE '%x%'
    AND TRIM (publicDescription) LIKE '%y%'
    AND TRIM (publicDescription) LIKE '%z%'
    OR TRIM (emplymentType) LIKE '%a%'
    AND TRIM (emplymentType) LIKE '%b%'
    AND TRIM (emplymentType) LIKE '%c%'
    AND TRIM (emplymentType) LIKE '%d%'
    AND TRIM (emplymentType) LIKE '%e%'
    AND TRIM (emplymentType) LIKE '%f%'
    AND TRIM (emplymentType) LIKE '%g%'
    AND TRIM (emplymentType) LIKE '%h%'
    AND TRIM (emplymentType) LIKE '%i%'
    AND TRIM (emplymentType) LIKE '%j%'
    AND TRIM (emplymentType) LIKE '%k%'
    AND TRIM (emplymentType) LIKE '%l%'
    AND TRIM (emplymentType) LIKE '%m%'
    AND TRIM (emplymentType) LIKE '%n%'
    AND TRIM (emplymentType) LIKE '%o%'
    AND TRIM (emplymentType) LIKE '%p%'
    AND TRIM (emplymentType) LIKE '%q%'
    AND TRIM (emplymentType) LIKE '%r%'
    AND TRIM (emplymentType) LIKE '%s%'
    AND TRIM (emplymentType) LIKE '%t%'
    AND TRIM (emplymentType) LIKE '%u%'
    AND TRIM (emplymentType) LIKE '%v%'
    AND TRIM (emplymentType) LIKE '%w%'
    AND TRIM (emplymentType) LIKE '%x%'
    AND TRIM (emplymentType) LIKE '%y%'
    AND TRIM (emplymentType) LIKE '%z%'
  )
ORDER BY dateAdded DESC
LIMIT 1000