I have a table with entries in a field like these:

Flowers blue
Flowers red
Flowers yellow

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.