Need SQL for multiple selection user profile fields

[pheadland]

I am writing some reports against the vB MySQL tables.

I have some user profile fields that are multiple selection checkboxes. If, for example, I have a set of checkboxes "One", "Two", "Three", how can I query users who have selected "One" and "Three", using a SQL SELECT? I assume that the userfields value for that user profile field is a set of bits, and that there is some funky MySQL function that lets me unpick the strings in userprofilefields.data to match that bit field?