Mysql filtering

hello
im sorry i know if i read much mysql docus etc i can do itself maybe…
but anyone has a working Mysql Statement (which notz making the RT3 DB
fault) where is can filter mails with Subject?
like all mails (zickets) with Subject 8272 > delete complete (with
users/content etc)
i only have von with “Resolving” (but without users etc)

thanks
bye
richard