List:General Discussion« Previous MessageNext Message »
From:Scott Hamm Date:October 10 2006 5:28pm
Subject:Counting char in a column
View as plain text  
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 toves
Did gyre and gimble in the wabe:
All mimsy were the borogoves,
And the mome raths outgrabe.
--------------------------------------------------------------------

Thread
Counting char in a columnScott Hamm10 Oct
  • Re: Counting char in a columnVisolve DB Team11 Oct