mysql – Split value from one field to two

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
Please follow and like us:
0