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
Post #1 of 5
Views: 7504
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
Mar 16, 2005, 6:16 AM
webmaster33
Veteran (2312 posts)
Mar 16, 2005, 6:16 AM
Post #2 of 5
Views: 7396
Shortcut
Quote Reply
Re: [afrayer] Search/Replace In reply to
UPDATE tablename SET column = '2005-06-30' WHERE column eq '2005-06-30';
Not checked if syntax is good, so use careful and do at your own risk!

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Mar 16, 2005, 6:24 AM
afrayer
User (105 posts)
Mar 16, 2005, 6:24 AM
Post #3 of 5
Views: 7372
Shortcut
Quote Reply
Re: [webmaster33] Search/Replace In reply to
Just what the doctor ordered. I know enough to modify that statement to work. I just didn't know where to begin. One of these days I'll invest in a good book on SQL commands.

Alan Frayer
Don't just read the news - make the news!
Your World News - http://yourworldnews.frayernet.com
Mar 16, 2005, 9:39 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Mar 16, 2005, 9:39 AM
Post #4 of 5
Views: 7366
Shortcut
Quote Reply
Re: [webmaster33] Search/Replace In reply to
column eq '2005-06-30';

should be;

column = '2005-06-30';

Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Mar 16, 2005, 9:50 AM
webmaster33
Veteran (2312 posts)
Mar 16, 2005, 9:50 AM
Post #5 of 5
Views: 7374
Shortcut
Quote Reply
Re: [Andy] Search/Replace In reply to
Yeah Wink However I noted, that I did not check the syntax, just showed the skeleton of the solution Smile

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...