Professional Web Applications Themes

char replacement - MySQL

Hi, I have a table with a field that contains a file path(www/docs/.../.../...) Some of the path contain this characters '' or ''. How can i do an update on this table to replace only the characters '' or '' by a 'e'. Thanks for your ideas VooDoo...

  1. #1

    Default char replacement

    Hi,
    I have a table with a field that contains a file path(www/docs/.../.../...)
    Some of the path contain this characters '' or ''.
    How can i do an update on this table to replace only the characters '' or
    '' by a 'e'.
    Thanks for your ideas
    VooDoo


    VooDoo Guest

  2. #2

    Default Re: char replacement

    VooDoo wrote:
    > Hi,
    > I have a table with a field that contains a file path(www/docs/.../.../...)
    > Some of the path contain this characters '' or ''.
    > How can i do an update on this table to replace only the characters '' or
    > '' by a 'e'.
    Check the Fine Manual at dev.mysql.com/doc, section on string functions.
    Christian Kirsch Guest

  3. #3

    Default Re: char replacement

    thanks, i have read this section:
    [url]http://dev.mysql.com/doc/refman/4.1/en/string-functions.html[/url]

    I have found this:
    mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
    -> 'WwWwWw.mysql.com'

    but the problem is that i don't know exactly the field. The path where i
    need to change the c character is not always the same...

    "Christian Kirsch" <ckbru6.de> a crit dans le message de news:
    436a51b9$0$21941$9b4e6d93newsread2.arcor-online.net...
    > VooDoo wrote:
    >> Hi,
    >> I have a table with a field that contains a file
    >> path(www/docs/.../.../...)
    >> Some of the path contain this characters '' or ''.
    >> How can i do an update on this table to replace only the characters ''
    >> or
    >> '' by a 'e'.
    >
    > Check the Fine Manual at dev.mysql.com/doc, section on string functions.

    VooDoo Guest

  4. #4

    Default Re: char replacement

    VooDoo <voodoonet38free.fr> wrote:
    > I have found this:
    > mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
    > -> 'WwWwWw.mysql.com'
    >
    > but the problem is that i don't know exactly the field. The path where i
    > need to change the c character is not always the same...
    Well, if the problem is indeterministic, you will neeed voodoo.

    Yours,
    Laurenz Albe
    Laurenz Albe Guest

  5. #5

    Default Re: char replacement

    ;)
    I sorted it out using php & an update.
    Thanks
    VooDoo
    "Laurenz Albe" <invitespam.to.invalid> a crit dans le message de news:
    [email]1131093989.752711proxy.dienste.wien.at[/email]...
    > VooDoo <voodoonet38free.fr> wrote:
    >> I have found this:
    >> mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
    >> -> 'WwWwWw.mysql.com'
    >>
    >> but the problem is that i don't know exactly the field. The path where i
    >> need to change the c character is not always the same...
    >
    > Well, if the problem is indeterministic, you will neeed voodoo.
    >
    > Yours,
    > Laurenz Albe

    VooDoo Guest

Similar Threads

  1. Contribute replacement
    By JSimmerin in forum Macromedia Contribute Connection Administrtion
    Replies: 3
    Last Post: April 15th, 01:28 AM
  2. #39533 [NEW]: ord() cast with (unsigned char), chr() with (signed char)
    By fred at cashette dot com in forum PHP Bugs
    Replies: 0
    Last Post: November 16th, 02:54 PM
  3. Replacement for Frontpage
    By Edwin Trouwee in forum PHP Development
    Replies: 6
    Last Post: September 19th, 03:22 PM
  4. string replacement
    By Ovide in forum PHP Development
    Replies: 2
    Last Post: August 28th, 06:04 AM
  5. Replies: 0
    Last Post: July 16th, 09:13 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