MySQL Forums
Forum List  »  Stored Procedures

How to loop through a comma separated string
Posted by: naren gokal
Date: May 22, 2012 01:58AM

How can i loop through comma separated string in MYSQL.

This is what i want

select exp from expertise where user_name = 'userName';
if exp != null then
LOOP
INSERT into table T1(exp1) VALUES(exp)
UNTIL NO COMMA FOUND
END IF;

Options: ReplyQuote


Subject
Views
Written By
Posted
How to loop through a comma separated string
5024
May 22, 2012 01:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.