How to split a single column values to multiple column values::
For Example: #Current table Field is like:: Name ------------ abcd efgh ijk lmn opq asd j. asdjja asb (asdfas) asd asd #Have to Change Like This :: first_name last_name ---------------------------------- abcd efgh ijk opq asd asdjja asb asd asd null #Query:: SELECT uid,IF( LOCATE(' ', `name`) > 0, SUBSTRING(`name`, 1, LOCATE(' ', `name`) - 1), `name` ) AS memberfirst, IF( LOCATE(' ', `name`) > 0, SUBSTRING(`name`, LOCATE(' ', `name`) + 1), NULL ) AS memberlast FROM `users` ORDER BY `users`.`uid` DESC