ms to boil down to a very easy grep statement, but a complicated SQL statement.
- Original Message -
From: "Reinhardt Christiansen" <[EMAIL PROTECTED]>
To: "Brent Baisley" <[EMAIL PROTECTED]>;
Sent: Thursday, May 31, 2007 2:41 PM
Subject: Re: Det
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 31, 2007 1:50 PM
Subject: Determining number of vowels in a string
I'm trying to do a select that will return the number of vowels/consonants
present in a string for eac
most readable query.
Thanks
- Original Message -
From: "Barry Newton" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 31, 2007 1:58 PM
Subject: Re: Determining number of vowels in a string
I'd rather do it in a sql statement rather than using a scripting language.
I'd rather do it in a sql statement rather than using a scripting language.
I'm thinking you might be able to do one select, accumulating 5
siubstring counts (a,e,i,o,u) into 5 variables, and then sum the
counts? I'll leave the testing to you. . .:-)
Barry Newton
--
MySQL General Mail
I'm trying to do a select that will return the number of vowels/consonants present in a string for each record. I thought a simple
grep was the way to go, but it appears the grep functions only tell you if a string is present. I would even settle for a grep
replace. Just replace the vowels with n
