WHERE clause for serialized field

[Lionel]

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



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



And I need to do query according to

i:5;s:1:"4";

where the "4" value is what varies.

[SirAdrian]

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.

[Lionel]

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