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` -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
