beowulf1416

Untitled

Nov 12th, 2015
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. SELECT ew.id, ew.did_e164, prov.title
  2. from data_entryway ew
  3. LEFT JOIN data_entryway_provider prov on prov.id = ew.entryway_provider
  4. WHERE
  5. ew.gateway_id IS NULL AND (
  6. TRIM(LOWER(ew.did_e164)) LIKE '%#{params[:q].downcase.strip}%'
  7. OR TRIM(LOWER(prov.title)) LIKE '%#{params[:q].downcase.strip}%'
  8. )
Advertisement
Add Comment
Please, Sign In to add comment