Received: from mail01.edsamail.com.ph (mail01.edsamail.com.ph [210.16.71.2]) by hub.org (8.10.1/8.10.1) with SMTP id e6799oW10053 for ; Fri, 7 Jul 2000 05:09:51 -0400 (EDT) Received: (qmail 3042 invoked by uid 508); 7 Jul 2000 09:09:25 -0000 Message-ID: <20000707090925.3041.qmail@mail01.edsamail.com.ph> From: brianb-pgsql@edsamail.com To: pgsql-sql@postgresql.org Subject: Search for underscore w/ LIKE Date: Fri, 07 Jul 2000 09:09:24 GMT Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/75 How do I use LIKE to search for strings with an underscore? The documentation (well, Bruce's book) says to use 2 underscores (__) but it doesn't work. For example: create table liketest ( somestr varchar(50) ); insert into liketest values ('foo_bar'); insert into liketest values ('foobar'); insert into liketest values ('snackbar'); insert into liketest values ('crow_bar'); -- I want to select strings with "_bar" select * from liketest where somestr like '%_bar'; somestr ---------- foo_bar foobar snackbar crow_bar (4 rows) -- Using double underscore doesn't work either select * from liketest where somestr like '%__bar'; somestr ---------- foo_bar foobar snackbar crow_bar (4 rows) -- Escaping w/ backslash doesn't work select * from liketest where somestr like '%\_bar'; somestr ---------- foo_bar foobar snackbar crow_bar (4 rows) Brian -- Brian Baquiran http://www.baquiran.com/ AIM: bbaquiran Work: (632)7182222 Home: (632)9227123