Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with alias_search as (
- SELECT
- array_to_string(aliases, ',') as string_array,
- id,
- name,
- opeid,
- city,
- state
- FROM universities
- )
- SELECT
- id,
- name,
- opeid,
- city,
- state
- from alias_search
- WHERE string_array ~* ?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement