[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.