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: Keith Ivey (keithsmokefreedc.org)
Date: Mon Oct 03 2005 - 12:18:25 CDT

Richard F. Rebel wrote:

> do I say REGEXP BINARY "<what?>"
>
> I have tried \000 \0 as they are common representations for binary null.

Have you tried "WHERE your_column LIKE '%\0%'"? That works for me.

--
Keith Ivey <keithsmokefreedc.org>
Smokefree DC
http://www.smokefreedc.org
Washington, DC

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