Hi,
You can actually unpack them using some fairly cryptic stuff. I would
only use this to unpack them once to re-store them as INT. Here's an
example:
CREATE TABLE ip (packed CHAR(4));
INSERT INTO ip (packed) VALUES (0xB16212C);
mysql> SELECT * FROM ip;
++
| packed |
++
|
I think Gerald was suggesting you convert the IP's into integers and
then do bitwise stuff on them. I don't know of a way to do what you're
asking.
Baron
Wagner, Chris (GEAE, CBTS) wrote:
Those functions concern dotted quad IP addresses, not packed binaries.
Anybody know of some obscure MyS
Those functions concern dotted quad IP addresses, not packed binaries.
Anybody know of some obscure MySQL functions to do bit logic on strings
or get MySQL to recognize a char sequence as an integer?
"Gerald L. Clark" wrote:
>
> Wagner, Chris (GEAE, CBTS) wrote:
> > Hi. I've got IP addresses st
