15 messages in com.mysql.lists.mysqlRE: a very tricky string extraction
FromSent OnAttachments
Ed Reed24 Mar 2005 11:49 
Dan Nelson24 Mar 2005 11:59 
Keith Ivey24 Mar 2005 12:00 
Joerg Bruehe24 Mar 2005 12:02 
Keith Ivey24 Mar 2005 12:04 
Jay Blanchard24 Mar 2005 12:07 
Jay Blanchard24 Mar 2005 12:13 
SGr...@unimin.com24 Mar 2005 12:31 
Ed Reed24 Mar 2005 13:02 
SGr...@unimin.com24 Mar 2005 13:18 
Ed Reed24 Mar 2005 13:36 
Eamon Daly24 Mar 2005 13:48 
Keith Ivey24 Mar 2005 13:53 
Ed Reed24 Mar 2005 14:04 
Eamon Daly24 Mar 2005 15:13 
Subject:RE: a very tricky string extraction
From:Jay Blanchard (jay.@niicommunications.com)
Date:03/24/2005 12:07:12 PM
List:com.mysql.lists.mysql

[snip] 01/01/05 SG Reviewed this 12/15/03 DSD Reviewed that 10/24/02 EWW Worked on that and tested this then stop to do something else 05/02/01 AW Did something 08/31/98 DSD Tested this 07/22/97 EWW Worked on that and did something

I need a Select statement that returns the Date for the first occurance of the 'Tested this' substring [/snip]

That is a bad way to keep a date, but try....I am not sure you can use MIN here...NOT TESTED

SELECT MIN(SUBSTRING(myField, 1, 8)) FROM myTable;