Off of the top of my head you can basically do a combination of all letters in big or (use IN) list. It should be pretty fast. I'm personally leaning to using REGEXP in mySQL yet, that would match the letters in a string and not exclude others, unless explicitly told to. Using a REGEXP is slow.
-- DVP > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 11, 2004 5:42 PM > To: [EMAIL PROTECTED] > Subject: check for certain characters > > 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??? > > thanks, > liz > > -- > 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]
