From: | Joao Paulo Felix <felix(at)cyclades(dot)com> |
---|---|
To: | "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | LIKE (SQL operator) |
Date: | 1998-06-30 02:10:57 |
Message-ID: | 35984931.CD44EDA6@cyclades.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello there,
I have a table called "products" which has a field named "item" with
following data stored:
"item"
PR1000
PR2000
PR3000
PRZE10
Lze100
Beta
Teta
Does PostgreSQL support the SQL operator "LIKE" . I have unsuccessfully
trying the following SQL query:
(SELECT * FROM products WHERE item LIKE '*PR*')
I would like to select all the rows where the field "item" has the
substring "PR" inside it.
Thanks in advance for any pointers/help'
JP
--
________________________________________________________________
Joao Paulo Felix
Cyclades Corporation voice: (510) 770-9727
41934 Christy Street fax: (510) 770-0355
Fremont, CA www.cyclades.com
________________________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-06-30 02:29:19 | Re: [GENERAL] LIKE (SQL operator) |
Previous Message | bdamato | 1998-06-29 19:15:30 | lo_read?? |