Professional Web Applications Themes

Split Column - MySQL

I have a singe column in a MYSQL database containing FirstName and Lastname. I would like to split itinto two seperate columns; Firstname and LastName. Is there an easy way to do this or can someone with more sql experience please offer a query that will do it? Thanks Fain...

  1. #1

    Default Split Column

    I have a singe column in a MYSQL database containing FirstName and
    Lastname. I would like to split itinto two seperate columns; Firstname
    and LastName. Is there an easy way to do this or can someone with more
    sql experience please offer a query that will do it?

    Thanks
    Fain

    cowiefr@yahoo.com Guest

  2. #2

    Default Re: Split Column

    com wrote:
     


    Probably best to loop through with you favourite programming language.
    You'll also need to consider what to do with names like 'Mary Anne Jones'.


    --
    Brian Wakem
    Email: http://homepage.ntlworld.com/b.wakem/myemail.png
    Brian Guest

  3. #3

    Default Re: Split Column

    Brian Wakem wrote: 
    > You'll also need to consider what to do with names like 'Mary Anne Jones'.[/ref]

    Many other cases, including "Dr. John C. Smith Jr., D.D.S",
    or "Cher". You have to make sure you handle all such cases that occur
    in your data, in whatever solution is used.

    SQL functions such as SUBSTRING(), SUBSTRING_INDEX() and INSTR() can
    help. See http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

    Regards,
    Bill K.
    Bill Guest

Similar Threads

  1. Column chart need column to exceed axis maximum value
    By zanedev in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: May 8th, 04:26 PM
  2. split single pdf doc to many based on line/column
    By MichaelL in forum Adobe Acrobat SDK
    Replies: 0
    Last Post: October 24th, 02:45 PM
  3. Move bound column to right of dynamic column in datagrid?
    By John E. in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: March 28th, 01:29 PM
  4. Convert an MS Access Yes/No column to a checkbox column in C# datagrid
    By Gregory Rampton in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: August 6th, 04:09 PM
  5. Replies: 0
    Last Post: July 7th, 08:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139