Обсуждение: LIKE (SQL operator)
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 ________________________________________________________________
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
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