StudentCodingHUB

Use programming to create innovative things.
  • new post

    Thursday, 16 April 2015

    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 

    No comments:

    Post a Comment