Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Applying 'XXX' to multiple lines

kaweng88's profile image kaweng88 posted 3 weeks ago in General Permalink

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' );

ansgar's profile image ansgar posted 2 weeks ago Permalink

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:

Description

kaweng88's profile image kaweng88 posted 2 weeks ago Permalink

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:

Description

thanks a lot!

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.