Occurrence of a Word? Anybody

Hi all just a quick question , dose anybody know how i can run a MYSQL query to produce the occurrence of each word in a row / col eg without using Like

+-----+
|data |
+-----+
|A B C|
|A C A|
|A A A|


A = 6
B = 1
c = 3

Would it better to do this in php , as i know it will take a while to process ?

 

Yeah, this sounds more like a scripting issue than database. The php function substr_count() looks like it would work for each individual word and row.

http://php.net/manual/en/function.substr-count.php