Professional Web Applications Themes

updating records - MySQL

Is there a way to update just a portion of some data. I have a entry field for serial numbers, but a new user entered the wrong serial numbers for a couple hundred serial numbers. She entered AXO-x instead of AX0-x. I would like to keep the existing numbers, but would like to update the AXO-x to AX0-x. Thanks for any help you can provide. A...

  1. #1

    Default updating records

    Is there a way to update just a portion of some data. I have a entry field
    for serial numbers, but a new user entered the wrong serial numbers for a
    couple hundred serial numbers. She entered AXO-x instead of AX0-x. I
    would like to keep the existing numbers, but would like to update the
    AXO-x to AX0-x. Thanks for any help you can provide.

    A


    Auddog Guest

  2. #2

    Default Re: updating records

    On Mon, 14 May 2007 08:02:29 -0500, "Auddog" <com>
    wrote:
     

    Something like :

    UPDATE table
    SET serial=CONCAT('AX0-',SUBSTRING(serial,5))
    WHERE serial LIKE 'AXO-%';
    subtenante Guest

  3. #3

    Default Re: updating records

    I will give that a try - thanks for the help/

    A

    "subtenante" <com> wrote in message
    news:com... 
    >
    > Something like :
    >
    > UPDATE table
    > SET serial=CONCAT('AX0-',SUBSTRING(serial,5))
    > WHERE serial LIKE 'AXO-%';[/ref]


    Auddog Guest

Similar Threads

  1. Replies: 1
    Last Post: October 9th, 02:17 AM
  2. Updating records in a database (php)
    By EliDee in forum Dreamweaver AppDev
    Replies: 18
    Last Post: June 28th, 05:16 PM
  3. Updating Multi records
    By rddave51 in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 10th, 04:37 PM
  4. Updating Multiple Records
    By Jordan Marton in forum Macromedia Dreamweaver
    Replies: 5
    Last Post: July 10th, 08:40 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