Skip site navigation (1) Skip section navigation (2)

SQL Regular expression

From: "Albert Chen" <chen6178(at)hotmail(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: SQL Regular expression
Date: 1999-07-14 20:42:46
Message-ID: 19990715034248.41842.qmail@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi,

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*';

Appearently, it doesn't work. Would anyone know how to do, thanks in 
advance.

-Albert


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

Responses

pgsql-general by date

Next:From: Peter EisentrautDate: 1999-07-14 21:25:05
Subject: Re: [GENERAL] Select from multiple db's
Previous:From: LOREAWMSDate: 1999-07-14 20:02:40
Subject: subscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group