mysql - Split value from one field to two

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