SQL question

[iffoiffy]

Hi,

I have a variable

$Variable_A= "Honda Ford Chevy Toyota BMW";


In my database I have field "Field_1" which has a value "Ford"

Now In my SQL select I want to pick record only when value of "Field_1" exists in $Variable_A

How can I do that

Thanks

 

[swampBoogie]

Assuming PHP

$q = "select <columnsOfInterest> from t
where field_1 in ('" . implode("','",explode(" ",$Variable_A)) . "')";

Untested.