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: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

I want to search my database table named ex,  whose the attribute is 
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 


Get Your Private, Free Email at


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-2017 The PostgreSQL Global Development Group