StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to change a value between two characters SQL
primarykey
Id
20377843
data
AcceptedAnswerId
20379718
AnswerCount
2
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-12-04T14:23:18.143
FavoriteCount
0
LastActivityDate
2013-12-04T15:45:42.067
LastEditDate
2017-05-23T10:32:16.343
LastEditorUserId
-1
OwnerUserId
1862808
ParentId
0
PostTypeId
1
Score
1
ViewCount
343
LastEditorDisplayName
text
Body
This question is divided into two parts. I will start with the first and obvious to the title: On the frontend I save this value: Hello you are: HERE The page you can visite is www.test.se In the db i am trying to write a script that will change the value between ":" and "The" Although the value that is stored is a bit diffirent in the db...there it looks like this: <pre><code>"Hello you are: HERE The page you can visite is" www.test.se </code></pre> I want to change "HERE" to "XXXX" My attempt so far: I found these two soloutions that are simillar to my question <a href="https://stackoverflow.com/questions/6388432/how-to-extract-strings-between-two-special-characters-in-tsql">Soloution One</a> <a href="https://stackoverflow.com/questions/16784117/using-charindex-len-and-substring-to-locate-certain-information-from-a-column">Soloution Two</a> Sadly i could not get this to work...I attempted this: <pre><code>select SUBSTRING( body, CHARINDEX(':', body) +1 , CHARINDEX('The',body)) from @temp </code></pre> I read up on substring and i am aware of that the last paramater is how long from the start position it should go but i want it to stopp at "The" and dont really know how to. Second part of this question: I only want to change the value of "HERE" how can i do that and avoid deleting the br taggs? EDIT: The value that i am trying to change is not always the same so a simple update statment will not work, thats why i need to find the value that i want to change
Tags
<mysql><sql>
Title
How to change a value between two characters SQL
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USThunD3eR
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POHow to change a value between two characters SQL
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COare ther always three br tags?
 singulars
 PostPostId
 POHow to change a value between two characters SQL
 UserUserId
 USniyou

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.