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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]