list filter help

I'm using 3 lists for my website and am using filters.
Users can select a checkbox for 3 categories and are able to select all of them if needed. Depending on what checkbox they selected, they'll appear in that specific list. The website for my client is about massage, make-up and esthetics. Now during the registration procedure the user can select whether she/he offers massage, make-up and esthetics. All 3 of them are possible as well..

I made a list for massage, make-up and esthetics by using the filter i.e: Offer = Massage. This works well if a user only selected massage during the registration process, but if the user selected massage and make-up for example then this doesn't work anymore. The list shows up empty, because the offer changed from just massage, to massage and make-up. How can I change the filter so that if the user selects multiple options, that this works as well?

you must use advanced filter
see
www.joomlapolis.com/forum/149-usage/158910-cb-list-search-on-multiselect-field#159763

bye

alright, but which command would be correct?

`cb_workfocus` LIKE'_UE_ESTHETICS' OR `cb_workfocus` LIKE'MAKE-UP'

this for example will show both those who work in esthetics AND make-up in the same list whereas I only want esthetics to show up in the list despite the fact that a user offers both Make-up and Esthetics

as mentioned before if I put `cb_workfocus` LIKE'_UE_ESTHETICS' it will show those who only chose esthetics, but if they selected more than just esthetics they won't show up.

use %% around value in LIKE statement.

sorry it did solve the problem, but I had to leave the OR plus the rest out.
thx!