Split a string in mysql

Split a string in mysql

split means divide a string into many pieces

TRIM ( SUBSTRING_INDEX ( display_name , ',' , -1))

• TRIM removes all white spaces from both side right and left 
• SUBSTRING_INDEX function split a string according to the symbol and starting point