How to change emailtemplate name using enhanced query

[Karl]

An email template with slash("/") exists.

I tried to use the enhanced query to remove this shash, and I used it as follows.

SELECT 'abc def' AS ECMEMAILTEMPLATE__NAME, et.name as ECMEMAILTEMPLATE__PRIMARYKEY FROM ECMEMAILTEMPLATE et WHERE et.name = 'abc / def';

Before running this query, I tried running the query below as a test, but maybe because it's PRIMARYKEY, NAME doesn't seem to change.

SELECT 'abc_test' AS ECMEMAILTEMPLATE__NAME, et.name as ECMEMAILTEMPLATE__PRIMARYKEY FROM ECMEMAILTEMPLATE et WHERE et.name = 'abc';

As a result, I think we need to change the name of the email template using the enhanced query, is there any way?

[rushikeshvartak]

You can change name from UI. Why you want to use enhanced query in this case ?

[Karl]

If I try to edit from UI it, 400 errors will occur because template name has slash. There's no way...

Can't I use the enhanced query? If so, would it be better to raise the ticket and request to delete the template?