find a string contained in an attribute

From: Karina Guardado <kguardado(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: find a string contained in an attribute
Date: 2010-03-24 21:20:43
Message-ID: 4a92b0c31003241420r7071cd7arb3d7fcee5915ccdc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szymon Guz 2010-03-24 21:25:42 Re: find a string contained in an attribute
Previous Message Paul Ramsey 2010-03-24 20:46:07 Re: Large index operation crashes postgres