pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feed[INTERFACES] Re: LIKE clause
4+ messages / 3 participants
[nested] [flat]
* [INTERFACES] Re: LIKE clause
@ 1999-10-25 16:03 Thomas Byrnes <tbyrnes@helioshealth.com>
1999-10-25 16:57 ` Re: [INTERFACES] Re: LIKE clause E.E. Mellor <eem21@cam.ac.uk>
0 siblings, 1 reply; 4+ messages in thread
From: Thomas Byrnes @ 1999-10-25 16:03 UTC (permalink / raw)
To: pgsql-interfaces; pgsql-general@postgresql.org
Alright, it seems simple enough, but I am having no luck figuring out the
syntax for the LIKE clause.
I have tried: WHERE name LIKE 'A*' and other similar combinations to no
avail. Anyone have any suggestions?
Thanks much,
Tom
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Re: LIKE clause
1999-10-25 16:03 [INTERFACES] Re: LIKE clause Thomas Byrnes <tbyrnes@helioshealth.com>
@ 1999-10-25 16:57 ` E.E. Mellor <eem21@cam.ac.uk>
0 siblings, 0 replies; 4+ messages in thread
From: E.E. Mellor @ 1999-10-25 16:57 UTC (permalink / raw)
To: Thomas Byrnes <tbyrnes@helioshealth.com>; +Cc: pgsql-interfaces; pgsql-general@postgresql.org
On Mon, 25 Oct 1999, Thomas Byrnes wrote:
> Alright, it seems simple enough, but I am having no luck figuring out the
> syntax for the LIKE clause.
>
> I have tried: WHERE name LIKE 'A*' and other similar combinations to no
> avail. Anyone have any suggestions?
LIKE 'A%', if I remember correctly.
Ewan.
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [INTERFACES] Re: LIKE clause
@ 1999-10-25 16:05 Thomas Byrnes <tbyrnes@helioshealth.com>
0 siblings, 0 replies; 4+ messages in thread
From: Thomas Byrnes @ 1999-10-25 16:05 UTC (permalink / raw)
To: pgsql-interfaces; pgsql-general@postgresql.org
Never mind got it
WHERE name LIKE 'A%'
Tom
-----Original Message-----
From: Thomas Byrnes [mailto:tbyrnes@helioshealth.com]
Sent: Monday, October 25, 1999 12:04 PM
To: 'pgsql-interfaces@postgresql.org'; 'pgsql-general@postgresql.org'
Subject: [INTERFACES] Re: LIKE clause
Alright, it seems simple enough, but I am having no luck figuring out the
syntax for the LIKE clause.
I have tried: WHERE name LIKE 'A*' and other similar combinations to no
avail. Anyone have any suggestions?
Thanks much,
Tom
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Re: LIKE clause
@ 1999-10-25 18:13 Jacob Christen <jacob-christen@home.com>
0 siblings, 0 replies; 4+ messages in thread
From: Jacob Christen @ 1999-10-25 18:13 UTC (permalink / raw)
To: pgsql-interfaces; pgsql-general@postgreSQL.org
-----Original Message-----
From: Thomas Byrnes <tbyrnes@helioshealth.com>
To: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>;
pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Date: Monday, October 25, 1999 1:56 PM
Subject: [INTERFACES] Re: LIKE clause
>Alright, it seems simple enough, but I am having no luck figuring out the
>syntax for the LIKE clause.
>
>I have tried: WHERE name LIKE 'A*' and other similar combinations to no
>avail. Anyone have any suggestions?
you're using the wrong wildcard character.
try:
SELECT name FROM my_table WHERE name LIKE 'A%'
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-10-25 18:13 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-25 16:03 [INTERFACES] Re: LIKE clause Thomas Byrnes <tbyrnes@helioshealth.com>
1999-10-25 16:57 ` E.E. Mellor <eem21@cam.ac.uk>
1999-10-25 16:05 RE: [INTERFACES] Re: LIKE clause Thomas Byrnes <tbyrnes@helioshealth.com>
1999-10-25 18:13 Re: [INTERFACES] Re: LIKE clause Jacob Christen <jacob-christen@home.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox