From: | "Jacob Christen" <jacob-christen(at)home(dot)com> |
---|---|
To: | <pgsql-interfaces(at)postgreSQL(dot)org>, <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [INTERFACES] Re: LIKE clause |
Date: | 1999-10-25 18:13:46 |
Message-ID: | 000a01bf1f18$8fa7fad0$4a0b030a@jchristen.educate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
-----Original Message-----
From: Thomas Byrnes <tbyrnes(at)helioshealth(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org <pgsql-interfaces(at)postgreSQL(dot)org>;
pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)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%'
From | Date | Subject | |
---|---|---|---|
Next Message | josen | 1999-10-25 18:52:48 | |
Previous Message | Aaron J. Seigo | 1999-10-25 17:23:19 | Re: [GENERAL] retrieving last 3 rows |
From | Date | Subject | |
---|---|---|---|
Next Message | Lars Strobor | 1999-10-25 21:54:07 | |
Previous Message | E.E. Mellor | 1999-10-25 16:57:53 | Re: [INTERFACES] Re: LIKE clause |