Professional Web Applications Themes

Remove left hand characters from a field. - MySQL

How do you remove, say the first 4 characters from a field? I have a bunch of department names in a column that is prefaced with accounting codes. Ex. 715-Human Resources, 813-Operations What's the MySQL query to remove the first 4 characters? (yes, they're consistent) Thanks! chris...

  1. #1

    Default Remove left hand characters from a field.

    How do you remove, say the first 4 characters from a field?

    I have a bunch of department names in a column that is prefaced with
    accounting codes.

    Ex. 715-Human Resources, 813-Operations

    What's the MySQL query to remove the first 4 characters? (yes, they're
    consistent)

    Thanks!
    chris

    Loony2nz Guest

  2. #2

    Default Re: Remove left hand characters from a field.

    Loony2nz says... 

    SELECT SUBSTR(<column_name>, 5) FROM <table_name>;

    GM
    Geoff Guest

  3. #3

    Default Re: Remove left hand characters from a field.

    On Jun 20, 5:49 pm, Geoff Muldoon <>
    wrote: 



    >
    > SELECT SUBSTR(<column_name>, 5) FROM <table_name>;
    >
    > GM[/ref]

    MUCHOS GRACIAS MI AMIGO!!

    That's just what I wanted!

    --Chris

    Loony2nz Guest

Similar Threads

  1. Left Hand Start for Facing Pages
    By Caroline_Barney@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 5
    Last Post: November 29th, 05:48 PM
  2. Left Hand Border when Exporting to GIF
    By Walt Kirspel in forum Macromedia Freehand
    Replies: 1
    Last Post: May 28th, 12:37 AM
  3. Camera for person with only left hand
    By Peter in forum Photography
    Replies: 9
    Last Post: July 31st, 05:01 PM

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