Guest User

Untitled

a guest
Mar 17th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. SELECT * FROM warehouse WHERE sku LIKE IN ($clean) AND style= :style9 ORDER BY sku ASC
  2.  
  3. There is no combination of LIKE & IN in SQL,so you have to use sql like
  4.  
  5. SELECT * FROM warehouse WHERE sku LIKE '%$clean%' AND style= :style9 ORDER BY sku ASC
  6.  
  7. select
  8. *
  9. from
  10. emp
  11. where
  12. name like @param +'%'
  13.  
  14. Select
  15. *
  16. from
  17. emp where name in ('abc', 'xyz')
  18.  
  19. SELECT * FROM warehouse WHERE sku RLIKE '^(AB|XY|FG)' AND ...
  20.  
  21. SELECT *
  22. FROM warehouse
  23. WHERE sku REGEXP REPLACE($clean,',','|') AND style= :style9
  24. ORDER BY sku ASC
Add Comment
Please, Sign In to add comment