SQL Command Help

[Kayot]

I get it, so to find item with class warrior bit set; since warrior is 1 I set it up like so:

Select classes From items where classes & 1;

And of course if I only want Warrior I just make it generic like so:

Select classes From items where classes = 1;

^-^ This makes things a hell of a lot easier. I was having it post process all the entry's which required a ton of leg work on the program. Now I can ease the processing that was needed. Goodbye 800ish lines, hello simple string insert.

Now to save this page onto my laptop so I can redesign that part of the program (No net access)

P.S. What do the other operators do? I'll probably find out, but short-cutting knowledge is always fun.

[samandhi]

BINARY Cast a string to a binary string
BIT_AND() Return bitwise and
BIT_COUNT() Return the number of bits that are set
BIT_LENGTH() Return length of argument in bits
BIT_OR() Return bitwise or
BIT_XOR() Return bitwise xor
& Bitwise AND
| Bitwise OR
^ Bitwise XOR
/ Division operator

The rest of them are here

[GeorgeS]

Thanks for the mask & nn reference. Never used it before, and just tried it for the items table and it works well. Wish I knew that before


GeorgeS