At 23:51 -0400 on 05/11/2004, Michael Stassen wrote about Re: check
for certain characters:
Then you could add NOT to Paul's query:
SELECT * FROM your table WHERE sequence NOT REGEXP '^[atcg]+$';
or, equivalently,
SELECT * FROM your table WHERE sequence REGEXP '[^at
Then you could add NOT to Paul's query:
SELECT * FROM your table WHERE sequence NOT REGEXP '^[atcg]+$';
or, equivalently,
SELECT * FROM your table WHERE sequence REGEXP '[^atcg]';
I suspect the latter may be faster, but you'd have to try them to be sure.
Note that pattern matching in mysql
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
> >th
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 v
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.
