List:General Discussion« Previous MessageNext Message »
From:Joseph S Brunzelle Date:January 21 2004 6:17pm
Subject:char count
View as plain text  
I'm try to write a query that will return the number of times a specified
character appears in a string (I want known how many times the character "M"
appears), but I cannot seem to figure out how to do that.  The select
statement is the following:

SELECT structure_aa_sequence from structure where apc_id="APC1114";

and this will return the following:

+----------------------------------------------------------------------+
| structure_aa_seq                                                     |
+----------------------------------------------------------------------+
| GGGGGGFVPNWYQHPDPALKYADDMEVYDYYQQYEAAKKAAREASTSSKKTAATSPALPRAKPHVTIA |
+----------------------------------------------------------------------+

Thanks

Joseph S. Brunzelle, Ph.D.
Life Sciences CAT
Dept of Mol. Pharm. and Biol. Chem.
Feinberg School of Medicine
Northwestern University
Phone (630)252-0629  FAX (630)252-0625
j-brunzelle@stripped

Thread
char countJoseph S Brunzelle21 Jan
  • Re: char countSteve Edberg21 Jan
    • Re: char countDan Nelson21 Jan