Returning on part of text field

[Anon]

I came into a project at the end to try and help out and I need help myself. Each record of the table has a keyword field (text) that is filled with keywords in this format "black,white,white man,dog,apple" and so on.
I need to know if there is a way for me to do a search like
select id,keywords from image where keywords LIKE '%,white,%'

But instead of the query returning the entire keyword field it would return just the keywords, like "white" and "white man".

[fandelem]

One solution would be this:

/ have $searchword come from a form or where ever /

     $sql = \"select id,keywords from image where keywords like \'%$searchword%\'\"; 
     $sql_result = mysql_query($sql) or die (\"Couldn\'t execute query. (getemail()) \".mysql_error()); 
     while ($row = mysql_fetch_array($sql_result)) { 
        /* this will create an array of all items delimited by a comma */
             $k_array = explode(\",\",$row[\'keywords\']; 
             $count = count($k_array); /* faster than running count() in for loop */
             for ( $i = 0; $i < $count; i++ )
             {
               if ( $k_array[$i] == $searchword )
                   do_something();
     } 

..or i could be way off. but this will explode the keywords into an array, loop through the array to find your specific match 🙂

cheers,

kyle

[hoops]

Thanks for your help but I was actually asking if there was a way to do this at the query level. There probably isn't but just wanted to see...