LIKE (SQL operator)

Поиск
Список
Период
Сортировка
Искать

LIKE (SQL operator)

От:
Joao Paulo Felix <felix@cyclades.com>
Дата:
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
________________________________________________________________

Re: [GENERAL] LIKE (SQL operator)

От:
The Hermit Hacker <scrappy@hub.org>
Дата:
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

Re: [GENERAL] LIKE (SQL operator)

От:
"Brett W. McCoy" <bmccoy@lan2wan.com>
Дата:
On Mon, 29 Jun 1998, Joao Paulo Felix wrote:

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

Yes, you would use it thusly:

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

The wildcards are '%' and '_', which function the same as '*' and '?',
respectively.

Brett W. McCoy           
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
"The number of UNIX installations has grown to 10, with more expected."
   -- The UNIX Programmer's Manual, 2nd Edition, June, 1972
FAQ