Update ticket with private comment
Adds a private comment to an existing ticket and updates its status. This example demonstrates setting comment_body, comment_public, and status in the UPDATE statement.
Update Tickets
SET comment_body='Closing this ticket'
, comment_public = 0 --or 1
, status='solved' --pending, new, closed
--, comment_body_html='Closing <b>this</b> ticket'
--, comment_author_id=123545
Where Id = 1234