SQL Regular expression

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