SQL Regular expression - Mailing list 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