This has surely got to be an easy thing to accomplish.
I want to compare two bit strings (in this case representing days of the week) to see if they match, e.g.
1111000 AND 0000100 = 0
1111100 AND 0000100 = 1
The output should be 1 or 0
When I try this in MySQL
SELECT 1111000 AND 0000100 seems to give 1
SELECT 1111000 & 0000100 gives an integer output.
How do I do it?