How do I search within a column (mysql like?)

[LeeMC1989]

Hi, I'm wondering how I would select a column from the database when searched through a LIKE.

 

example..

 

$text = 'BLAHSet Fire To The Rain';

$query = mysql_query("SELECT musictitle FROM music WHERE musictitle LIKE '%Set Fire To The Rain%%'") or die(mysql_error());

 

But its not fetching anything.. (I have tried a combination of %'s, _'s, and /'s) I also tried REGEXP..

 

Basicly I have a PHP file reading a RSS feed and what I want to do is search for each song name and and output the RSS with my info from database, but the RSS feed title displays as follows (1 Adele - Set Fire To The Rain) but the song title and artist are in the same title..? I can't figure it out..

[gristoi]

why have you got two %% at the end of your query? try:

$query = mysql_query("SELECT musictitle FROM music WHERE musictitle LIKE '%Set Fire To The Rain%'") or die(mysql_error());

[fenway]

You're going to get burned on whitespace.