How to check if meta value is IN serialized array

How To
1

Hey there,

I have some postmeta which are stored as serialized array:

metakey => userroles
metavalue => a:2:{i:0;s:13:“administrator”;i:1;s:10:“student”;}

How can I do a meta query for bricks query loop if a value e.g. “administrator” is IN this serialized array?

image

2

OK i tried something different now, not using a meta query but a condition. Unfortunately this doesn’t work either…

image

From the value it returns:

metakey => userroles
metavalue => a:2:{i:0;s:13:“administrator”;i:1;s:10:“hp_student”;}

image

3

did you ever find a solution for this? I’m having the same issue with dates in a serialized array

4

FYI–I was able to create a code snippet that unserializes arrays into individual fields so you can query.