I. If you want to count the same number of words, ie:
DOE found 3 times
Bob — it occurs 2 times etc, it can be done either through stored procedures or other brute force (in php), or (better) to normalize the data to one line only had one word, then you can use the GROUP BY operator.
II. If you want to count the number of the same names (which I think you want), then the database again it is better to normalizovat on this principle:
1. The longest word in the string to take the name, unless it ends in "ICH", "ech" and other harakternye for patronymic the end, otherwise take the next longest word in the string.
2. The shortest word in the string to take the name.
These data is recorded in a table with columns Name and Surname (or some other suitable format) and you can save the keys on the source zapisi. Then on the field Name to use GROUP BY.
Something like that. Your problem is the unnormalized data.