Professional Web Applications Themes

partial string - MySQL

I have a text field in my database that contain a significant amount of text, where I just want to go through each row and delete from the string everything between <body> and </body>. Any ideas? Thank you in advance....

  1. #1

    Default partial string

    I have a text field in my database that contain a significant amount of

    text, where I just want to go through each row and delete from the
    string everything between <body> and </body>.

    Any ideas?


    Thank you in advance.

    The Guest

  2. #2

    Default Re: partial string

     

    With the tags:

    select
    substr(left(COLUMN,instr(COLUMN,'</body>')+length('</body>')-1),instr(COLUMN,'<body>'))
    from table;

    Without the tags:

    select
    substr(left(COLUMN,instr(COLUMN,'</body>')-1),instr(COLUMN,'<body>')+length('<body>'))
    from table;



    Regards
    Dimitre


    Radoulov, Guest

  3. #3

    Default Re: partial string

     [/ref]
    [...]
     
    [...]

    Misread the post :)

    So:

    1. Backup your table.
    2.

    If you want to delete <body> ... </body>, tags included:

    update TABLE set COLUMN=concat(left(COLUMN, instr(COLUMN,'<body>')-1),
    substr(COLUMN, instr(COLUMN,'</body>')+length('</body>')));

    or

    If you want to delete <body> ... </body> and leave the tags:

    update TABLE set COLUMN=concat(left(COLUMN,
    instr(COLUMN,'<body>')+length('<body>')-1),
    substr(COLUMN, instr(COLUMN,'</body>')));



    Regards
    Dimitre



    Radoulov, Guest

Similar Threads

  1. Partial Transparency
    By Ilya Razmanov in forum Adobe Illustrator Windows
    Replies: 10
    Last Post: May 27th, 07:33 AM
  2. Partial Borders
    By David Lally in forum Adobe Photoshop Elements
    Replies: 1
    Last Post: August 30th, 06:42 PM
  3. Partial Default Value?
    By Charlie in forum Microsoft Access
    Replies: 2
    Last Post: August 7th, 08:47 PM
  4. Put partial text
    By Alvin Bakker in forum Macromedia Director Lingo
    Replies: 1
    Last Post: August 5th, 12:59 PM
  5. Partial Index
    By Maggy in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 2nd, 01:29 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