the output of the query should be: all the records that contain even one letter other than a,t,c or g.
Liz Quoting Paul DuBois <[EMAIL PROTECTED]>: > At 21:41 -0400 5/11/04, [EMAIL PROTECTED] wrote: > >hi, > > I have a field which is a genome sequence and I need to check if > each of > >the entries made for the sequence field contains only a,t,c or g in the > string > >and no other characters. > >how will i give the query??? > > It depends. You can find matching values with > > WHERE col_name REGEXP '^[atcg]+$' > > but you don't say what you want for output, so beyond that it's > difficult > to say what the rest of the query should look like. > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]