Re: [GENERAL] SQL Regular expression

1999-07-14 Thread John M. Flinchbaugh
On Wed, 14 Jul 1999, Albert Chen wrote: > 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*'; use one of the following: select subj

[GENERAL] SQL Regular expression

1999-07-14 Thread 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.