Professional Web Applications Themes

Noob question, probably very simple (sorry I don't know this myself) - Microsoft SQL / MS SQL Server

I wanted to know how to do the following in SQL. I have a table with a column (of text) called "Answer" In answer is an XML substring that I'd like to be able to update, for example: If Answer was equal to: "This is my answer <SOME TAG>Stuff</SOME TAG> and that was my tag" and I wanted to change this to: "This is my answer <NEW TAG>Other Stuff</NEW TAG> and that was my tag" Now, I know I could simply get the original answer, modify it and simply update it; however, I'd like to be able to update just ...

  1. #1

    Default Noob question, probably very simple (sorry I don't know this myself)

    I wanted to know how to do the following in SQL.

    I have a table with a column (of text) called "Answer"

    In answer is an XML substring that I'd like to be able to update, for
    example:

    If Answer was equal to:

    "This is my answer <SOME TAG>Stuff</SOME TAG> and that was my tag"

    and I wanted to change this to:

    "This is my answer <NEW TAG>Other Stuff</NEW TAG> and that was my tag"


    Now, I know I could simply get the original answer, modify it and simply
    update it; however, I'd like to be able to update just based upon what tags
    I need to change, not knowing the answer in its whole.

    How do I make a SQL query that simply replaces <SOME TAG>Stuff</SOME TAG>
    with the new one in every answer that has <SOME TAG> in it...?

    Thanks,

    WTH:)


    WTH Guest

  2. #2

    Default Re: Noob question, probably very simple (sorry I don't know this myself)

    "WTH" <com> wrote in message
    news:u$phx.gbl... 
    tags 

    Anything wrong with this?

    UPDATE [table] SET [answer] = REPLACE([answer], '<SOME TAG>Stuff</SOME
    TAG>', '<NEW TAG>Other Stuff</NEW TAG>')
    --
    Daisy The Cow
    Now playing: David Morales Presents The Face - Needin U


    Daisy Guest

  3. #3

    Default Re: Noob question, probably very simple (sorry I don't know this myself)

    > UPDATE [table] SET [answer] = REPLACE([answer], '<SOME TAG>Stuff</SOME 

    Coolio, thanks :). I'll try that. It looks like it should work just fine.

    WTH


    WTH Guest

Similar Threads

  1. Noob question about the server
    By vbMarkO in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: July 20th, 08:18 PM
  2. 3d text. noob question
    By Whitestarisligerzero in forum Macromedia Director 3D
    Replies: 1
    Last Post: October 8th, 09:30 PM
  3. sorry noob question
    By the rebel in forum Macromedia Director 3D
    Replies: 3
    Last Post: September 26th, 12:17 PM
  4. Stupid Noob Question
    By slowlrner in forum Macromedia Freehand
    Replies: 3
    Last Post: February 27th, 05:33 AM
  5. Noob question
    By drew146 webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 1
    Last Post: October 5th, 11:24 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