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:[EMAIL PROTECTED] > 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`
signature.asc
Description: This is a digitally signed message part