mysql - Split value from one field to two - Stack Of Codes

Breaking

Monday, 4 December 2017

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

No comments:

Post a Comment

Topics

PHP (27) CodeIgniter (22) SQL (4) Facebook (3) HTML (3) Blogger (2) Constructor (2) Destructor (2) Google (2) Aadhaar (1) Agent (1) Browser (1) CSS (1) Cakephp (1) Constants (1) How to (1) India (1) Ip address (1) JS (1) Jquery (1) Meta Tags (1) Robots (1) Scraping Data (1) escape_str (1) htaccess (1) iS mobile (1) javascript (1) mysqli (1)