Postgres Pro
Downloads
Home   >   mailing lists

LIKE (SQL operator) - Mailing list pgsql-general

From Joao Paulo Felix
Subject LIKE (SQL operator)
Date
Msg-id 35984931.CD44EDA6@cyclades.com
Whole thread Raw
Responses Re: [GENERAL] LIKE (SQL operator)  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
Re: [GENERAL] LIKE (SQL operator)  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-general
Tree view 
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
________________________________________________________________

pgsql-general by date:

Previous
From: Roman Volkoff
Date:
Subject: unsubscribe
Next
From: "Brett W. McCoy"
Date:
Subject: Re: [GENERAL] LIKE (SQL operator)