Mysql query find substring

Question

I have a table like this:

country (id, name)

I want to find the id where for example the search string is "Russian Federation" and in my table is stored the value "Russia".

Pratically the stored value is a substring of the search string.

KaeL · Accepted Answer · 2013-07-08 01:26:00Z

4

You can try it like this:

SELECT *
  FROM Country
  WHERE 'Russian Federation' LIKE CONCAT('%', Name, '%')

Here's the SQL Fiddle Demo.

answered Jul 8, 2013 at 1:26

KaeL

3,6612 gold badges31 silver badges59 bronze badges

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

Comments

Gordon Linoff · Accepted Answer · 2013-07-08 01:44:09Z

1

If that is the case, then you can do:

select *
from country
where concat(' ', SEARCHSTRING, ' ') like concat('% ', name, ' %')

Or you can use find_in_set():

select *
from country
where find_in_set(name, replace(SEARCHSTRING, ' ', ',')) > 0;

answered Jul 8, 2013 at 1:23

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

using find_in_set function it seem that doesn't works sqlfiddle.com/#!2/bfb49/13/0