PDA

View Full Version : adminemail bitfield


Kirk Y
07-09-2006, 04:03 AM
Would someone mind posting a query for me that sets a users adminemail to 0? It's bit 5, bitfield 16. I'm still confused with the whole bitfield and sql thing.

Paul M
07-09-2006, 11:07 AM
UPDATE user SET options = options - 16 WHERE (options & 16) AND userid = 123

Kirk Y
07-09-2006, 03:20 PM
Thanks Paul.