Advertisement
Guest User

Untitled

a guest
Apr 17th, 2014
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. e.g SELECT * from 'users' where 'job' IN("1", "2", "3");
  2.  
  3. e.g jobs ["1", "2"] is stored in the database.
  4.  
  5. occupations
  6. ----------------------
  7. name user_id
  8. ______________________
  9. Film 1
  10. Singer 1
  11. Copywriter 2
  12.  
  13. SELECT * FROM `occupations` WHERE name LIKE "%Film%"
  14.  
  15. SELECT * FROM `occupations` WHERE name LIKE "%Film%" OR name LIKE "%Singer%"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement