Re: [GENERAL] SQL Regular expression

On Wed, 14 Jul 1999, Albert Chen wrote:
> I want to search my database table named ex, whose the attribute is
> subject,
> and list the results that matches the keyword 'electric'.
> I run the SQL command: SELECT subject FROM ex WHERE subject='*electric*';

use one of the following:

select subject from ex where subject~'.*electric.*';

or

select subject from ex where subject like '%electric%';

the first uses postgresql's regular expressions, which are much like unix
regex. the second uses the sql standard like clause. this one will be
more portable to other dbms.

____________________}John Flinchbaugh{______________________
| -> glynis(at)hjsoft(dot)com <- john(at)cs(dot)millersv(dot)edu |
| glynis(at)netrax(dot)net http://www.hjsoft.com/~glynis/ |
~~Powered by Linux: Reboots are for hardware upgrades only~~