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