Advertisement
Guest User

Untitled

a guest
Feb 5th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. select *
  2. from (
  3. select *, data->'platform' platform, data->'user_agent' user_agent
  4. from website_activity
  5. ) foo
  6. where (platform::text like '%linux%' and user_agent::text like '%64%');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement