LIKE (SQL operator)

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: Whole Thread | Raw Message | 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
________________________________________________________________

Responses

Browse pgsql-general by date

  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??