Postgres Pro
Downloads
Home   >   mailing lists

Re: find a string contained in an attribute - Mailing list pgsql-general

From Szymon Guz
Subject Re: find a string contained in an attribute
Date
Msg-id e4edc9361003241425x6b2172a5kf28ab76add2767b6@mail.gmail.com
Whole thread Raw
In response to find a string contained in an attribute  (Karina Guardado <kguardado@gmail.com>)
Responses Re: find a string contained in an attribute  (Karina Guardado <kguardado@gmail.com>)
Re: find a string contained in an attribute  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
2010/3/24 Karina Guardado <kguardado@gmail.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%';


regards
Szymon Guz

pgsql-general by date:

Previous
From: Karina Guardado
Date:
Subject: find a string contained in an attribute
Next
From: Karina Guardado
Date:
Subject: Re: find a string contained in an attribute