[GENERAL] SQL Regular expression

[Albert Chen]

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