Odd Select Query

[tmh766]

Hey

 

I can't seem to figure out how to write this query.

 

I have a PHP variable set to, for example:

$match='a,b,c';

and want to check if a MySql field's value is within the variable match, not the other way around like usual.

 

So if theMySql field had a value of "a", that row would be returned because the field's value is a substring of the variable match.

 

Tim

 

 

[corbin]

You could use IN.

 

 

Except for your string would need to be formatted differently.

 

 

Example query:

 

SELECT * FROM table1 WHERE field1 IN('a', 'b', 'c');

 

 

So, if you had a comma separated list in PHP, you could do something like this:

 

"SELECT * FROM table1 WHERE field1 IN ('" . implode("', '", explode(",", $input)) . "');"

 

 

Edit:  By the way, it would be wiser to explode() the array and then mysql_real_escape_string all of the pieces before putting it back together.

[tmh766]

Hey

 

Thank you so much, I didn't know about that.

[corbin]

;p