Re: Is Pattern Matching possible with MySQL?

2002-05-23 Thread Egor Egorov
Chan, Thursday, May 23, 2002, 10:36:04 AM, you wrote: >> I have a table with 2 fields, of char type. >> >> One field contains a 'ID number'. >> Another field 'Aliases' contains a list of comma-delimited values. (eg >> aaa,bbb,ccc) >> >> Is it possible using MySQL functions to return the 'IDnumb

Is Pattern Matching possible with MySQL?

2002-05-23 Thread Chan WieVia ICM N MC MI E3 Extern
> Hi, > > I have a table with 2 fields, of char type. > > One field contains a 'ID number'. > Another field 'Aliases' contains a list of comma-delimited values. (eg > aaa,bbb,ccc) > > Is it possible using MySQL functions to return the 'IDnumber' when the > string "aaa" exists in 'Aliases' ?