Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
StuntasticAudi
Starting Member
1 Post |
 Posted - 2006-06-07 : 20:02:55
|
| Hello, I'm new to the site, I've been trying to find help and i hope this is the right place.In my MySQL database i have a table 'A' with a colum called 'Description'. Inside 'Description' there is some text and a link to a page. I have over 2500 Description fields and all have the same link inside but i need to change that link to a new one and i dont know how to update the description column with the new link. I know how to change just everything in it but its like this:text text text text linkso how do i just change the link in the description column.Anyone?thanks in advance. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-07 : 20:53:04
|
| update tablenameset columnname=replace(columnname,' link to replace ',' new link ')where columnname like '%linkhere'--i specified the where so you'll only traverse the affected rowsHTH--------------------keeping it simple... |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-06-07 : 21:48:24
|
"In my MySQL database"Please take note that this is a MS SQL Server Forum. You might want to post your question on MySQL on a MySQL forum like www.dbforums.com
KH |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-07 : 21:53:36
|
isn't that the database name like Test?  quote:
Originally posted by khtan
"In my MySQL database"Please take note that this is a MS SQL Server Forum. You might want to post your question on MySQL on a MySQL forum like www.dbforums.com
KH
--------------------keeping it simple... |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-06-07 : 22:32:47
|
quote:
Originally posted by jen
isn't that the database name like Test?
Maybe
KH |
|
|
|
|
|
|
Update query help needed! anyone?