mysq select from comma delimited

[delphipgmr]

Location: milwaukee, wi
Posts: 8
mysql select
ok, ive been playing with this for an hour now..

the database field productUpgradesProdID contains a comma delimited string (like "1,2,3")

Im trying to do a select if a value is in there... like in this case $save_prodid = "1"

(productaccessory is just true or false)

I tried:

$sql = "SELECT * FROM product_inventory
WHERE productAccessory and ($save_prodid IN (productUpgradesProdID))

which i thought should work....but it doesnt find anything (it should), any ideas?

[delphipgmr]

I figured it out.

WHERE productAccessory and productUpgradesProdID
REGEXP \"^{$save_prodid,|,$save_prodid,|,$save_prodid$|$save_prodid$\"}

[tomhath]

Arrays inside of rows is bad design. Use a child table so you can select using a join with a normal WHERE clause instead of cramming delimited strings into a single field.

[delphipgmr]

i know, i didnt design it, i just inherited it.