Link to home
Start Free TrialLog in
Avatar of rschoenbach
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
ASKER CERTIFIED SOLUTION
Avatar of D B
D B
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial