Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM warehouse WHERE sku LIKE IN ($clean) AND style= :style9 ORDER BY sku ASC
- There is no combination of LIKE & IN in SQL,so you have to use sql like
- SELECT * FROM warehouse WHERE sku LIKE '%$clean%' AND style= :style9 ORDER BY sku ASC
- select
- *
- from
- emp
- where
- name like @param +'%'
- Select
- *
- from
- emp where name in ('abc', 'xyz')
- SELECT * FROM warehouse WHERE sku RLIKE '^(AB|XY|FG)' AND ...
- SELECT *
- FROM warehouse
- WHERE sku REGEXP REPLACE($clean,',','|') AND style= :style9
- ORDER BY sku ASC
Add Comment
Please, Sign In to add comment