From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
---|---|
To: | JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com> |
Cc: | "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org> |
Subject: | Re: [SQL] using like |
Date: | 1999-05-25 23:43:37 |
Message-ID: | Pine.BSI.3.91.990525194106.26771N-100000@access1.lan2wan.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Tue, 25 May 1999, JT Kirkpatrick wrote:
> i'm trying to query my database (6.4.2 through odbc ms access) to find all
> records matching a "like" statement. from psql i am trying this -- select
> autoinv, company from table1 where company like 'Alice'; -- but it doesn't
> work! i could run whatever works in psql as a passthrough query in
> access97, if i could get it to work in psql! i'd expect the query to pull
You need to use the wildcard for like clauses, which is % in pgsql, but
Access uses '*':
select autoinv, company from table1 where company like '%Alice%';
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
You probably wouldn't worry about what people think of you if you could
know how seldom they do.
-- Olin Miller.
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 1999-05-25 23:45:51 | Re: [SQL] using like |
Previous Message | JT Kirkpatrick | 1999-05-25 20:37:46 | RE: [SQL] using like |