I have an issue that I am stuck in,
I have a table called wpg_original_word
with field tags, which contains comma separated values and what I want to achieve is search for tags which are starting with the letter 'd'
I have written the query
SELECT DISTINCT tags FROM wpg_original_word WHERE tags LIKE 'd%' ;
It returns the whole string like 'Diabetes, Nutrition, Dietician'
, but I want only the Diabetes, Dietician
.
Any help?