Re: find a string contained in an attribute

2010/3/24 Karina Guardado <kguardado(at)gmail(dot)com>

> Hi,
>
> I want to know if it is possible to search for a string of characters
> inside an attribute for example I have the following table and values
>
> cod_unidad | nombre_uni
> ------------+---------------------------------------------
> 1 | Facultad de Ciencias Naturales y Matemática
> 2 | Facultad de Ciencias Humanidades
> 3 | Facultad de Ingeniería
> 4 | Facultad de Agronomía
> 5 | Oficinas Centrales
> 6 | test
>
>
> I want to retrieve all the rows where I find the word Ciencias for example.
> Is there a function or with select is possible to do it?
>
> thanks in advance,
>
> karina
> El Salvador, Centroamerica
>

For example something like this should work:

SELECT * FROM table WHERE nombre_uni like '%Ciencias%';

more you can find here:
http://www.postgresql.org/docs/8.4/interactive/functions-matching.html

regards
Szymon Guz