Re: BUG #5535: Backslash in condition for LIKE statement is not seen

"Jeff Benjamin"  wrote:
 
> Seems one cannot use a backslash character in a LIKE condition.
 
By default that has special meaning as an escape character.
 
Try this:
 
select * from test where pattern like E'\\w%' escape '#';
 
or this:
 
select * from test where pattern like E'\\\\w%';
 
-Kevin