Search for underscore w/ LIKE

From: brianb-pgsql(at)edsamail(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: Search for underscore w/ LIKE
Date: 2000-07-07 09:09:24
Message-ID: 20000707090925.3041.qmail@mail01.edsamail.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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 <brianb(at)edsamail(dot)com>
http://www.baquiran.com/ AIM: bbaquiran
Work: (632)7182222 Home: (632)9227123

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Paul McGarry 2000-07-07 09:37:27 Re: MAX() of 0 records.
Previous Message Paul McGarry 2000-07-07 09:00:14 Re: [SQL] MAX() of 0 records.