Horton

Re: [GENERAL] LIKE (SQL operator)

Marc G. Fournier <scrappy@hub.org>

View thread View on postgr.es
From: The Hermit Hacker <scrappy@hub.org>
To: Joao Paulo Felix <felix@cyclades.com>
Cc: "pgsql-general@postgreSQL.org" <pgsql-general@postgreSQL.org>
Date: 1998-06-30T02:29:19Z
Lists: pgsql-general 
On Mon, 29 Jun 1998, Joao Paulo Felix wrote:

> 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*')

SELECT * FROM products WHERE item LIKE '%PR%'


Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org