Is there a way to use like for searching a '\' ?
I have a column which contains a windows path ex c:\temp\foo
I 'am searching all entries which contains this path but I never match.
I tried :
like 'c:\temp\foo%'
like 'c:\\temp\\foo%'
like 'c:&\temp&\foo%' escape '&'
is there another way ?