Help translating RT query to mysql

Dear List,

Asking humbly for some mysql help;

I have a query in a queue in RT that has these conditions:

Requestor LIKE Companyname
Subject LIKE Internal
Status = resolved
Queue = Main
Created > 2004-06-01 07:00:00 GMT

I need a translation of that into mysql command-line client syntax …

Which would be pretty easy if I were mysql fluent… so am asking for
someone to show me with one example.

Thanks!

Kind regards,

Dave D

Dave Dennis wrote:

Dear List,

Asking humbly for some mysql help;

I have a query in a queue in RT that has these conditions:

Requestor LIKE Companyname
Subject LIKE Internal
Status = resolved
Queue = Main
Created > 2004-06-01 07:00:00 GMT

I need a translation of that into mysql command-line client syntax …

Which would be pretty easy if I were mysql fluent… so am asking for
someone to show me with one example.
You can do it yourself:
Request Tracker Wiki
turn on full sql log then do search and look into log for
‘SELECT main.* from Tickets …’

			Best regards.