Applying 'XXX' to multiple lines

Hi there, is there a shortcut function that allows me to insert '' into multiple lines in heidisql (for query WHERE XXX in etc. Currently im adding the '' on excel (im sure theres a better way!)

SELECT * FROM tbl WHERE NAME IN ( john jimmy jamie jack jiff );

becomes

SELECT * FROM tbl WHERE NAME IN ( 'john', 'jimmy', 'jamie', 'jack', 'jiff' );

No, there is no such formatter in HeidiSQL.

But you can - as an alternative - select wanted rows in the grid, then rightclick "Quick filters" to generate such a clause:

No, there is no such formatter in HeidiSQL.

But you can - as an alternative - select wanted rows in the grid, then rightclick "Quick filters" to generate such a clause:

thanks a lot!