From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | sharmad(at)goatelecom(dot)com, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Replacing "LIKE" with "=" |
Date: | 2001-12-10 19:43:43 |
Message-ID: | web-524765@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Sharmad,
> Can I replace a query statement having a "LIKE" with a statement
> having "="
> still getting the same functionality
>
> Like for ex:-
> SELECT * from teble_name WHERE name LIKE "%name%";
You cannot.
WIthin the SQL standard, you must use "LIKE" if you want to use
wildcards. PostgreSQL also supports the Regular Expression operator "~"
which does a different kind of pattern matching. See "Functions and
Operators" in the online PostgreSQL documentation, or purchase a copy of
"PostgreSQL: Introduction and Concepts".
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Manuel Andrade Muñoz | 2001-12-10 19:48:30 | postgresql v 7.1.3 error |
Previous Message | Josh Berkus | 2001-12-10 19:38:03 | Re: Poolman/mySQL transaction exception on connect |