using 'LIKE IN' in mysql query

Question

So it's just a simple question I have this query. It's not working so I just thought I'd make sure that this isn't possible.

SELECT * FROM warehouse WHERE sku LIKE IN ($clean) AND style= :style9 ORDER BY sku ASC

What is `$clean`? What is the expected outcome? `LIKE` and `IN` both exist, but `LIKE IN` doesn't, and I can't think of any artifact that would behave the way I think you want (if `$clean` were a list of string patterns). — RandomSeed, Dec 22 '14 at 17:31

score 1 · Answer 1 · edited May 23 '17 at 11:43

1

I don't recognize LIKE IN as a thing.

You might try sku LIKE '%' + ($clean) + '%'

Or, if you're looking for it the other way around: ($clean) LIKE '%' + sku + '%'

Is there a combination of "LIKE" and "IN" in SQL? Here is a discussion of using Contains, if you would like to try using that.

edited May 23 '17 at 11:43

Community

1
1

answered Dec 22 '14 at 17:25

Coding Orange

548
4
7

score 1 · Answer 2 · answered Dec 22 '14 at 17:35

1

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

answered Dec 22 '14 at 17:35

jay.jivani

1,560
1
16
33

score 0 · Answer 3 · answered Dec 22 '14 at 17:51

Like and In both are different thing, you can easily understand from the below snippet of code, hopefully this will help you to remove your confusion :)

select 
    *
from
    emp
where
    name like @param +'%'

Select
   *
from
   emp where name in ('abc', 'xyz')

score 0 · Answer 4 · answered Dec 22 '14 at 17:54

Not knowing what your $clean value looks like (or your sku values or expected results) I can only guess, but REGEXP, also known as RLIKE, might be useful here.

Say you're looking for SKU's like 'AB%', 'XY%', and 'FG%'. You can do that with RLIKE as follows:

SELECT * FROM warehouse WHERE sku RLIKE '^(AB|XY|FG)' AND ...

score 0 · Answer 5 · answered Dec 23 '14 at 09:38

You could use REGEXP to achieve what your trying to achieve, so you query will look like

SELECT * 
FROM warehouse 
WHERE sku REGEXP REPLACE($clean,',','|') AND style= :style9 
ORDER BY sku ASC

Going on the assumption that $clean is comma delimited list of values.

using 'LIKE IN' in mysql query

5 Answers5