How to seperate comma from a string in MYSQL

FIND_IN_SET :
This is the function used in mysql to seperate comma from a string.


string _emp_id ="1,2,3,5"

in the procedure use
find_in_set(emp_id,_emp_id);


so here it automatically seperate the _emp_id , first it will take 1 , then 2 ,3, 4 and 5 and do the operation.


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: