finding a value in a field which contains an array

[glennn.php]

i have a field, "models", which will contain an array such as "Acura, Camaro, Blazer" - i'm trying to learn how to use IN to get any row that would contain "Acura" within that field.

 

SELECT * from TABLE WHERE 'Acura' IN 'models'...? that didn't work...

 

anyone...?

 

thanks much

 

GN

[trq]

Its generally a poor design that leads you to storing comma separated strings within a field. You should look at normalization techniques and give each of those delimited values its own row.

[glennn.php]

very true. i'm not good at JOINS and multiple tables, especially when the client wants to pay budget scale...

 

be that as it is, can you show me how i'd get Acura out of that array? i am in fact researching how i'd normalize this table - i hate to do a bad job even when the money isn't right.

 

i'm much obliged...

[trq]

IN isn't going to help, you'll need to use LIKE.

 

SELECT * FROM tbl WHERE Models LIKE '%Acura%';

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_find-in-set

[glennn.php]

IN isn't going to help, you'll need to use LIKE.

 

SELECT * FROM tbl WHERE Models LIKE '%Acura%';

 

that's waht i ended up doing, thanks -