Get specific values from comma separated string in mysql

Question

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?

I'm having a similar issue in SQL Server. You need to split the string, maybe with a stored procedure or a function. — Donnie Rock, Feb 21 '14 at 08:21
Maybe this post could help you http://stackoverflow.com/questions/11835155/mysql-split-comma-seperated-string-into-temp-table — Donnie Rock, Feb 21 '14 at 08:24

score 3 · Accepted Answer · answered Feb 21 '14 at 08:32

3

You could split the string with PHP, use the following code

<?php

$string = 'Diabetes, Nutrition, Dietician';
$array = explode(',', $string);
$result = array();
foreach ($array as $part) {
    if (substr(strtolower(trim($part)),0,1) == 'd') {
        array_push($result, trim($part));
    }
}

var_dump($result);

See it in action here. http://codepad.org/SVk7FPx9

answered Feb 21 '14 at 08:32

Tuim

2,491
1
14
31

Thanks for the idea, I have to change a little bit according to my want – Vidya L Feb 21 '14 at 10:34

score 0 · Answer 2 · edited Jul 17 '14 at 09:07

0

You can use in_array() to check for a string in your query and then print it.

edited Jul 17 '14 at 09:07

Gottlieb Notschnabel

9,408
18
74
116

answered Feb 21 '14 at 08:26

user986959

620
2
7
22

I want to check values starting with a specific letter – Vidya L Feb 21 '14 at 08:29

Get specific values from comma separated string in mysql

2 Answers2