escaped underscore

Gonzalo "D?az" <[email protected]> Wed, 13 Sep 2006 18:33:51 -0700 (PDT)

Newsgroups	gmane.comp.db.mckoi
Message-ID	<[email protected]>

Does Mckoi understand escaped underscores in a LIKE
statement? For example, 

  SELECT * FROM EMAILS_TABLE WHERE EMAIL LIKE '%\_%'

  ... so that it returns all email addresses
containing underscores.

I tried the backslash but it doesn't seem to work. I
also tried a varied number of backslashes (2, 4, etc),
to allow for Java backslash escaping, regular
expressions, etc., to no avail.

If true, is there a workaround? I can use prepared
statements, but still need to write the right SQL.
Thanks in advance

  Gonzalo DÃaz

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]