Professional Web Applications Themes

mysql how to erase something that is inside the tags <img>something</img> that is inside a column - MySQL

mysql how to erase something that is inside the tags <img>something</ img> that is inside a column UPDATE jos_content SET title = REPLACE(title,'(<img>).+(</img>)','') but is not working please help...

  1. #1

    Default mysql how to erase something that is inside the tags <img>something</img> that is inside a column

    mysql how to erase something that is inside the tags <img>something</
    img> that is inside a column
    UPDATE jos_content SET title = REPLACE(title,'(<img>).+(</img>)','')

    but is not working

    please help

    fhelik Guest

  2. #2

    Default Re: mysql how to erase something that is inside the tags <img>something</img> that is inside a column

    On 29 Apr 2007 20:06:08 -0700, fhelik <com> wrote:
     

    I am a newbie myself! Hopefully what I am about to offer will "work",
    but if not, I hope some of the more well versed will show me the error
    of my ways, thus answering your original question.

    update jos_content set title = '<img></img>' where left(title,5) =
    '<img>' and right(title,6) = '</img>'.

    This of course assumes that the img tags and what's in between them is
    the "only" thing in the column. If not, then use of "like" and
    "substr" and "concat" would be this newbie's next try.

    HTH
    Lee
    Lee Guest

  3. #3

    Default Re: mysql how to erase something that is inside the tags <img>something</img> that is inside a column

    On Apr 30, 5:23 am, Lee Peedin <rr.com> wrote: 


    >
    > I am a newbie myself! Hopefully what I am about to offer will "work",
    > but if not, I hope some of the more well versed will show me the error
    > of my ways, thus answering your original question.
    >
    > update jos_content set title = '<img></img>' where left(title,5) =
    > '<img>' and right(title,6) = '</img>'.
    >
    > This of course assumes that the img tags and what's in between them is
    > the "only" thing in the column. If not, then use of "like" and
    > "substr" and "concat" would be this newbie's next try.
    >
    > HTH
    > Lee[/ref]

    thanks lee

    ok this is one of the arrows:

    <span style='line-height:25px'><img width='50' height='50' border='1'
    align='right' src='http://200.74.194.10/recursos/mini/spyware.gif'>Un
    proyecto de ley estadounidense, conocido popularmente como Spy Act
    "Ley de Espionaje", tiene como una de sus intenciones declaradas poner
    fin

    the tag starts <img and finish >

    plase lee eny help is great

    fhelik Guest

Similar Threads

  1. Prevent certain tags inside custom control
    By MRe in forum ASP.NET Building Controls
    Replies: 0
    Last Post: August 24th, 02:07 PM
  2. Getting inside a template column
    By G Dean Blake in forum ASP.NET Data Grid Control
    Replies: 2
    Last Post: January 19th, 09:54 PM
  3. Erase Inside Question...
    By MArtin Chiselwitt in forum Macromedia Flash
    Replies: 1
    Last Post: August 30th, 05:28 PM
  4. Replies: 1
    Last Post: March 1st, 11:48 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