2010/3/24 Szymon Guz <mabewlun@xxxxxxxxx>: > 2010/3/24 Karina Guardado <kguardado@xxxxxxxxx> >> >> 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 better to use a fulltext it is much faster on tables larger than small create index foo on tab using gin(to_tsvector('simple', nombre_uni)) select * from tab where to_tsvector('simple', nombre_uni) @@ to_tsquery('simple', 'Ciencias'); Regards Pavel Stehule -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
