OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE: How to match a binary null in a varchar column???

From: Andrew Braithwaite (Andrewmultimap.com)
Date: Mon Oct 03 2005 - 11:52:09 CDT

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`

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql