Re: a very tricky string extraction

[Keith Ivey]

Eamon Daly wrote:
> SELECT
> LEFT(SUBSTRING_INDEX(LEFT(log, LOCATE('\n', log, LOCATE('tested this', 
> log)) - 1), '\n', -1), 8)
> FROM test WHERE log LIKE '%tested this%'

Another possibility:

    SELECT SUBSTRING(log, LOCATE('\n', SUBSTRING(log, 1,
       LOCATE('Tested this', log)-1))+1, 8)
    FROM test WHERE LOCATE('Tested this', log);

-- 
Keith Ivey <keith@stripped>
Smokefree DC
http://www.smokefreedc.org
Washington, DC