Split query in MYSQL . SELECT SPLIT('a,b,c,d', ',') as third; how to output come this format in MYSQL Third a b c d I want query in MYSQL only help me quickly

Hi, Please refer the below link http://stackoverflow.com/questions/11100501/split-comma-separated-values-from-one-column-to-2-rows-in-the-results-mysql Regards, Iftikar

hi, there is no built in function to spit data, you have to write your own function for this Please refer below link it might help to create your own finction. http://blog.fedecarg.com/2009/02/22/mysql-split-string-function/ http://code-cocktail.in/mysql-split-string-in-query/ https://gist.github.com/mikedamage/277782

refer to this link http://stackoverflow.com/questions/3928325/split-keywords-for-post-php-mysql/3929161#3929161 http://stackoverflow.com/questions/3908966/mysql-procedure-to-load-data-from-staging-table-to-other-tables-need-to-split-up/3909888#3909888