Not sure if anyone uses bitwise AND SQL, but I find this info extremely useful. It makes what would take lots of code oftherwise into 1 line.
Say you want to find all items for a mage , you would enter
SELECT classes,id, name FROM items WHERE classes & '4096'
In my job, things like this makes life easier.
GeorgeS
|