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

PHP Code:

a:6:{i:1;s:11:"Violette AC";i:2;s:3:"ASM";i:3;s:35:"Port-au-Prince - Stade Sylvio Cator";i:4;s:17:"Digicel Ouverture";i:5;s:1:"4";i:6;s:14:"First Division";} 


And I need to do query according to

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

where the "4" value is what varies.

[Adrian Schneider]

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