Split query in MYSQL

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

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