Is there LIKE IN in mysql?

Question

Possible Duplicate:
Is there a combination of “LIKE” and “IN” in SQL?

I asked this my self some time ago: http://stackoverflow.com/questions/3014940/is-there-a-combination-of-like-and-in-in-sql — selfawaresoup, Jul 09 '10 at 20:06
@Techpriester: THANK YOU! I was sure I'd answered that recently, couldn't find the question... I marked this as a duplicate because MySQL has native Full Text Search functionality, and there is no `LIKE IN` in SQL at all. — OMG Ponies, Jul 09 '10 at 23:06

score 4 · Answer 1 · answered Jul 09 '10 at 20:03

4

No.

But there is fulltext search. Maybe that goes into the right direction?

mysql> SELECT id, body   
    -> FROM articles WHERE MATCH (title,body) AGAINST
    -> ('Keyword1 Keyword2 Keyword3');

answered Jul 09 '10 at 20:03

Pekka

score 4 · Answer 2 · edited May 23 '17 at 12:19

4

Per this prior stackoverflow question, you might have better luck with a REGEXP query:

edited May 23 '17 at 12:19

Community

answered Jul 09 '10 at 20:05

Fosco

1

+1 nice! It's going to be slow, but exactly what the OP wants (as far as can be told what he wants.) – Pekka Jul 09 '10 at 20:05
This is valid, but Full Text Search (FTS) is a far better way to handle the situation. – OMG Ponies Jul 09 '10 at 23:08

score 0 · Answer 3 · answered Jul 09 '10 at 20:05

0

No, but you may be able to use RLIKE depending on your version of MySQL

answered Jul 09 '10 at 20:05

Mark Baker

score 0 · Answer 4 · answered Jul 09 '10 at 20:06

0

No, but you could use REGEXP.

...WHERE field REGEXP 'abc|xyz'

answered Jul 09 '10 at 20:06

TerryMatula

4 Answers4