Unserialize data and check it against an id in MySQL

Question

I have a row of IDs in a database that has been serialized.

What I'm trying to do is check those serialized IDs against a known ID to see if it should be excluded or not.

for example:

"SELECT * FROM mydb WHERE id = 4 AND checkID != 'an id in the serialized column' "

What's the best way to go about this?

Answer 1

You're not saying what form the IDs are in, but the basic way is using IN:

AND checkid NOT IN (1,2,3,4,5,6,7);