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 |
|
NickyT
Starting Member
1 Post |
 Posted - 2009-03-23 : 16:05:43
|
Hello,Im working inside of PHPmyAdmin and currently, i have to navigate through 15 tables editing each and every record to change a value.Is there any way i can execute a sql code that can:Find the value: http://www.nickythorne.com inside every table in every record in the database and then replace that value with: http://www.techthorne.com This will save me a heck of a lot of time.Thanks in advance,Nicky |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-03-23 : 16:08:55
|
| This is a Microsoft SQL Server site, so our T-SQL answers might/will not work for you. Here is what I'd use in SQL Server:SELECT 'UPDATE ' + TABLE_NAME + ' SET Column1 = REPLACE(Column1, ''SomeText'', ''SomeOtherText'')'FROM INFORMATION_SCHEMA.TABLESI'd suggest posting your question on a site that deals with the technology that you are using. Try dbforums.comTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
SQL Code Question