advanced filter

hi i have a db column cb_works with an imploded array in it (multichoice select):
shop|*|office|*|laboratory|*| ecc...
i want to set a list filter on this column:
i tried advanced filter:
`cb_works` LIKE '%[Office]%'

doesnt work

thewebsurfer wrote: hi i have a db column cb_works with an imploded array in it (multichoice select):
shop|*|office|*|laboratory|*| ecc...
i want to set a list filter on this column:
i tried advanced filter:
`cb_works` LIKE '%[Office]%'

doesnt work

of course it doesn't.

why are you using [ ]?
and why are you using Office instead of office ?

i found [] method somewhere online, i tried {} and doesnt work too.

i use "Office" cause i can't change the CB dropdown option value, so i have the capitalization:
<option value="Office">Office</option>

i solved with
`cb_works` LIKE '%Office%'