From: Jacob Christen <jacob-christen@home.com>
To: pgsql-interfaces@postgreSQL.org
To: pgsql-general@postgreSQL.org
Subject: Re: [INTERFACES] Re: LIKE clause
Date: Mon, 25 Oct 1999 14:13:46 -0400
Message-ID: <000a01bf1f18$8fa7fad0$4a0b030a@jchristen.educate.com> (raw)
-----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%'
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jacob-christen@home.com, pgsql-general@postgreSQL.org
Subject: Re: [INTERFACES] Re: LIKE clause
In-Reply-To: <000a01bf1f18$8fa7fad0$4a0b030a@jchristen.educate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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