Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

Search/Replace

Mar 16, 2005, 5:30 AM
afrayer
User (105 posts)
Mar 16, 2005, 5:30 AM
Views: 7878
Shortcut
Quote Reply
Search/Replace
Extreme novices at SQL probably shouldn't go there, but here I am.

I have a table with a field containing a given date, let's say 2005-03-31. I want to change this date to 2005-06-30. I can do this one at a time in MySQLMan, and I can do this individually in LinksSQL. What I can't see how to do is do this in bulk.

I have over 600 of these dates to change. I either need to know where/how to do so in MySQLMan, or I need the MySQL syntax to do so in SQL Monitor, because I'll never get the dates changed manually! Crazy

Any help?

Alan Frayer
Don't just read the news - make the news!
Your World News - http://yourworldnews.frayernet.com
Subject Author Views Date
Thread Search/Replace afrayer 7878 Mar 16, 2005, 5:30 AM
Thread Re: [afrayer] Search/Replace 		webmaster33 7756 Mar 16, 2005, 6:16 AM
Post Re: [webmaster33] Search/Replace 		afrayer 7732 Mar 16, 2005, 6:24 AM
Thread Re: [webmaster33] Search/Replace 		Andy 7727 Mar 16, 2005, 9:39 AM
Post Re: [Andy] Search/Replace 		webmaster33 7734 Mar 16, 2005, 9:50 AM