rschoenbach
asked on
SQL Search String for Value
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:
select
top 50 lg_trace.eventtime,
lg_trace.comment,
hs_clients.name
from
lg_trace
inner join hs_clients on hs_clients.clientid = lg_trace.clientid
where
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
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:
select
top 50 lg_trace.eventtime,
lg_trace.comment,
hs_clients.name
from
lg_trace
inner join hs_clients on hs_clients.clientid = lg_trace.clientid
where
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.