Gabriel Fernandez wrote:
> 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 :-)
Try
select code from codes where code ~ '(4)' ;
HTH. Stefano
--
Dott. Stefano Bargioni
Biblioteca della Pontificia Universita' della Santa Croce - Roma
<mailto:[EMAIL PROTECTED]> <http://www.usc.urbe.it>
Personal web page: <http://www.usc.urbe.it/html/php.script?bargioni>
--- "Si apud bibliothecam hortulum habes, nihil deerit" (Cicerone) ---
