Re: Seeking rows whit \

[Francisco Reyes <lists@xxxxxxxxxxxxxxxx>]

Gurjeet Singh writes:

> Thus, writing a pattern that actually matches a literal backslash means 
> writing four backslashes in the statement.

Thanks.

select * from mytable where f1 like '%\\\\%'; 
Worked.

For the archives..

After reading section 4.1.2.2 
Also found that these other one also works
select * from mytable where f1 ~ $$\\$$;
select * from mytable where f1 like $$%\\%$$;