MySQL - Is there a way to match a table data to a given string rather than vice versa.

Question

SELECT * FROM disney;
+++++++NAME+++++++
lion king
cinderella
the little mermaid
+++++++++++++++++++

$string = "i love the movie lion king, it rocks!"

I want to get the NAME from disney where the NAME is inside the given string. It's kinda like:

'SELECT * FROM disney WHERE NAME LIKE "%'.$string.'%";'

only the other way around (but didn't work well when i tried it).

Is there a MYSQL function to check whether a data in a table cell exists in a given string?

Thanks a lot! ().i'm working with PHP!

Answer 1

I think the following should work (I remember trying to do the same once, and I think this is what I used) :

'SELECT * FROM disney WHERE "' . $string . '" LIKE CONCAT("%",NAME,"%")';

Answer 2

There's the INSTR Function which should work for this:

SELECT * FROM disney WHERE INSTR('i love the movie lion king, it rocks!', name) > 0

Answer 3

You can also try MySQL's FULLTEXT search feature which only works with MyISAM tables:

$query = "SELECT * FROM disney WHERE MATCH(NAME) AGAINST ('$text')";