Re: Counting char in a column

2006-10-10 Thread Visolve DB Team
27;Mysql '" Sent: Tuesday, October 10, 2006 10:58 PM Subject: Counting char in a column I'm running MySQL 5.0.15 on Windows system. How do I count how many specific char is there in a column, for example finding 'c' in lowercase string of "Characteristics" wou

Counting char in a column

2006-10-10 Thread Scott Hamm
I'm running MySQL 5.0.15 on Windows system. How do I count how many specific char is there in a column, for example finding 'c' in lowercase string of "Characteristics" would total to 3. -- `Twas brillig, and the slithy tove