I am trying to search the following string stored in a mysql database.
Agent :(c0):10/18/2007 03:01:42.239 PM r: getVersion 0.000ms
I would like to return just the 0.000 ms part. Any suggestions?
My current query looks like:
top 50 lg_trace.eventtime,
inner join hs_clients on hs_clients.clientid = lg_trace.clientid
hs_clients.name = 'dgamdt101' and
lg_trace.eventtime between '2007-10-18 03:00:00 PM' and '2007-10-19 06:00:00 AM' and
lg_trace.comment like '%ms'
order by eventtime asc