01-19-06, 08:49 #1Registered User
- Join Date
- Jan 2006
Unanswered: Trim down strings to least common base
I have a table with entries in a field like these:
Now I want get MySQL to return me the least common base of the string,
which is "Flowers" in the above case.
Is there a way to do this in a single SELECT query?
Any hints are appreciated.