Re: Changing a field's data in every record
- Date: Sun, 19 Feb 2017 09:04:10 -0800
- From: debt <debt@xxxxxxxxxxxxx>
- Subject: Re: Changing a field's data in every record
> On Feb 19, 2017, at 3:50 AM, Brad Barnett <lists@xxxxxxx> wrote:
Thanks a million, Brad! That works perfectly. SUBSTRING_INDEX didn’t come up in my searches so this is the first I’ve heard of it.
Also, as you could see, it wasn’t a true timestamp. It is only used for viewing, not for searching or sorting, so a text field worked perfectly fine for that purpose. However, after reading everyone’s replies, I convinced her to change that field to DATETIME and to lose the ‘@‘. Now they have the best of both worlds - more readable data and a true DATETIME field that will be more useful should they ever need it to be.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql