I read in the docs (section 9.7.1) that the backslash... \ ... is the default escape char to use in “like” expressions. Yet when I try it, it doesn’t seem to work the ay I expect. Here’s an example...
select name from templates where name like ‘%\_cont\_%’;
name
----------------------------------
cgidvcontrol
x8idvcontrol
etc....
I would expect to NOT see these because the “cont” is not preceded by and followed by an underscore (because I escaped them with \).
Please advise.
Thanks
-dave