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
– Donnie Rock, Commented Feb 21, 2014 at 8:21
Maybe this post could help you stackoverflow.com/questions/11835155/… — Donnie Rock
– Donnie Rock, Commented Feb 21, 2014 at 8:24

Tuim · Accepted Answer · 2014-02-21 08:32:45Z

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, 2014 at 8:32

Tuim

2,5211 gold badge16 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vidya L Over a year ago

Thanks for the idea, I have to change a little bit according to my want

dialogik · Accepted Answer · 2014-07-17 09:07:51Z

0

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

edited Jul 17, 2014 at 9:07

dialogik

9,59218 gold badges79 silver badges122 bronze badges

answered Feb 21, 2014 at 8:26

user986959

6402 gold badges7 silver badges22 bronze badges

1 Comment

Vidya L Over a year ago

I want to check values starting with a specific letter

Collectives™ on Stack Overflow

Get specific values from comma separated string in mysql

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related