yes
you can do that via mostly any mysql tool like phpMyAdmin, MySQLFront, etc.
the preffered tool is MySQL's mysqldump tool running from the command line.
why so difficult query?
SELECT * FROM kdn_message ORDER BY updated DESC LIMIT 0,1
this should return the last one record from kdn_message by date (updated).
if you want to get the last record from specific ticketid:
SELECT * FROM kdn_message WHERE ticketid=1234 ORDER BY updated DESC LIMIT 0,1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.