I have a field in mysql that is stored as a binary value. This field represents multiple roles a person can have and the 'stacking' of those roles.
admin - 00000001
user - 00000010
Someone that is an admin & moderator would be 00000101.
Given this query, only someone with an admin role is returned:
Select first_name, last_name
where role = '00000001';
Is it possible?