Looping through array field in mysql statement?

Question

I was given a database that is a little weird, but I am not able to change it. There is a field that is set as an array but holds ids that I need to access in where clauses. Here is the field set up:

TABLE: PROMOS
promo_id   |    contract_ids
-----------------------------
 1               23,34,54
 2               13,34,55
 3               20,30

I need to do an sql query to get all promo_ids where contract id = 34

mysql_query("SELECT promo_id FROM Promos WHERE contract_ids = '34'

Is there a way to do this?? Thanks for any help!

juergen d · Accepted Answer · 2012-11-01 16:35:57Z

3

SELECT promo_id FROM Promos 
WHERE FIND_IN_SET(34, contract_ids) > 0

See FIND_IN_SET doc

answered Nov 1, 2012 at 16:35

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Looping through array field in mysql statement?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related