[GENERAL] Problem with LIKE operator

[Gabriel Fernandez]

Hi,

I have some problems using LIKE within strings which have brackets.

For example if i do:

select code from codes where code like '(4)' ;

i do not obtain nothing. But in the DB indeed there is a row whose code
is '(4)'.

I have tried to escape the brackets with '\\(4\\)' or with ' \(4\)' but
it doesn't work.

How can i do it ?

Gabi :-)