Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ew.id, ew.did_e164, prov.title
- from data_entryway ew
- LEFT JOIN data_entryway_provider prov on prov.id = ew.entryway_provider
- WHERE
- ew.gateway_id IS NULL AND (
- TRIM(LOWER(ew.did_e164)) LIKE '%#{params[:q].downcase.strip}%'
- OR TRIM(LOWER(prov.title)) LIKE '%#{params[:q].downcase.strip}%'
- )
Advertisement
Add Comment
Please, Sign In to add comment