WHERE clause for serialized field
 

Is it possible to to do a where clause for a serialized field?

SELECT * from TABLE where customfield = 'specific serialized item'

here is the serialized field

And I need to do query according to

where the "4" value is what varies.

Is this a standard vB. table?

If not, change the table schema - serializing data like that is poor design. OR, if it's too late, duplicate the data into a new table, but only the stuff that is search-able.

As for your question, you could probably use a regular expression to match it. Very slow, though.

it's the vb event table and those are the calendar custom fields