Posted by mr gumpy on 10/10/94 11:39

I want to update a number of timestamps that look like this 1027094500
to look like this 20051027094500
This is the sort of thing I have been trying with no success:

UPDATE `newCalls` WHERE timeStamp LIKE '10%' SET timeStamp LIKE '200310%'

I would be grateful if anyone could tell me what I should be doing.
Thanks
G

• Next in forum: Re: mysql wildcards
• Prev in forum: Re: email processing script, need help trying to catch =0D and =5f encoded characters
• Thread view: mysql wildcards

[Reply to this message]