From: Richard F. Rebel (rrebelwhenu.com)
Date: Mon Oct 03 2005 - 12:02:22 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

I have tried several formulations using BINARY, but cannot see how to
apply it.

do I say REGEXP BINARY "<what?>"

I have tried \000 \0 as they are common representations for binary null.

On Mon, 2005-10-03 at 17:52 +0100, Andrew Braithwaite wrote:
> Hi,
>
> You could try the binary operator:
>
> http://dev.mysql.com/doc/mysql/en/charset-binary-op.html
>
> Cheers,
>
> Andrew
>
> -----Original Message-----
> From: Richard F. Rebel [mailto:rrebelwhenu.com]
> Sent: Mon, 03 Oct 2005 17:48
> To: Untitled
> Subject: How to match a binary null in a varchar column???
>
>
> Hello,
>
> How do you match all rows with a binary null (octal 000) in a given
> column.
>
> I have tried all sorts of strange combinations of REGEXP and LIKE with
> no results. I have dug in the manual, but can't seem to find anything.
>
> Any help would be appreciated.
>
--
Richard F. Rebel

cat /dev/null > `tty`

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBDQWQex1ZaISfnBu0RAnUpAJ4nppn5eAVcyzbdHh+HJlYfBDZ4owCcDw5U
I5hYWfDaaSaRZc8prOU6d/0=
=91tb
-----END PGP SIGNATURE-----

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]