I have a problem in mySQL that goes as follows:
- Count the instances of a substring in a string field in a mySQL database
- Order the results by the number of occurrences of that substring (DESC)
I have never done anything other than rudimentary queries.. I can't find a solution elsewhere.