Skip to main content

Splitting Comma-Separated Values In MySQL

CREATE TABLE numbers (n INT);
 INSERT INTO numbers VALUES
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8),
(9),

 

 

https://cdn.sisense.com/wp-content/uploads/image-01-comma-blog.png

select 
  id, 
  substring_index(
    substring_index(email_recipients, ',', n), 
    ',', 
    -1
  ) as email
from dashboards
join numbers
  on char_length(email_recipients) 
    - char_length(replace(email_recipients, ',', '')) 
    >= n - 1
 
https://cdn.sisense.com/wp-content/uploads/image-03-comma-blog.png 


Reference Site : https://www.sisense.com/blog/splitting-comma-separated-values-in-mysql/

Comments

Post a Comment

Popular posts from this blog

Recursive array calls one after another through promise

 data = [1,2,3,4] rules = [                     function(d){ return d.map(x => x * 2); },                     function(d){ return d.map(x => x * 2); }                ] recursive(0,rules,data); function somelongrunningprocess(rule, data){     var d = $.Deferred();     setTimeout(function(){ var result = rule.call(undefined,data); d.resolve(result); },1000);     return d; } function recursive(index, rules, data) {             if(index < rules.length) {                 $.when(somelongrunningprocess(rules[index],data)).then(function(response){                     console.log("after_rule",respon...
Post a Comment
Read more

Javascript Generator as promise

     function* makeIterator(data) {       for(i in data){                 yield data[i];         }     }         function runPull() {         var obj = it.next();         var val;         console.log("RunPull Clicked",obj);         if(!obj.done) {             val = obj.value;             val.click();             setTimeout(function(){                 runPull();             },200);         }     }     ru...
Post a Comment
Read more