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: 2210
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: 2197
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: 2195
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 (17366 posts)
Andy's avatar
Mar 16, 2005, 9:39 AM
Post #4 of 5
Views: 2191
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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Mar 16, 2005, 9:50 AM
webmaster33
Veteran (2312 posts)
Mar 16, 2005, 9:50 AM
Post #5 of 5
Views: 2191
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...