Split query in MYSQL

Question

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

Iftikar Hussain · Answer

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

Jignesh Trivedi · Answer

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

Sanjeeb Lenka · Answer

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