MySQL Select against String

Question

I have a string "Hello Help Me, Stackover flow, Google users, Google Plus, ". and in my database table I have

ID    TITLE
--    -----

 1.   Stackover flow
 2.   Google Plus
 3.   Help Me
 4.   Another Title
 5.   Hey World

I need to get IDs 1, 2, 3 using MySQL query, because the string contain those words.

Hows it possible in MySQL

EDIT

select ID, post_title, 
from wp_posts 
where 'Hello Help Me, Stackover flow, Google users, Google Plus,' like concat('%', post_title, '%') and post_type = 'mediawords';

Gordon Linoff · Accepted Answer · 2013-12-23 15:39:21Z

2

You want to use like:

select t.id
from table t
where @string like concat('%', title, '%');

This does a string match, so substring can interfere. If you want to take into account the delimiter (', '), then do:

select t.id
from table t
where concat(', ', @string) like concat('%, ', title, '%, ');

answered Dec 23, 2013 at 15:39

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

coderex Over a year ago

:) thats working :D an additional "," makes the error... Thank you u

Johnbot · Accepted Answer · 2013-12-23 15:45:04Z

1

You can use the in clause:

select id 
from table
where title in ('Hello Help Me', 'Stackover flow', 'Google users', 'Google Plus')

answered Dec 23, 2013 at 15:45

Johnbot

2,1791 gold badge24 silver badges25 bronze badges

Collectives™ on Stack Overflow

MySQL Select against String

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related