Since r4412, HeidiSQL allows to append WHERE clauses to an existing filter clause, in the Data tab. So, when you now rightclick a field > Quick filter > "col = whatever", press the Shift key while clicking, and HeidiSQL appends the newly created filter with an AND instead of overwriting the old one.
Thanks to zykaradek for the idea!
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.
New feature: Additive quick filters
Nice Feature! But there´s a small bug: When I select the second Quick Filter (with shift) it is added to the first filter, but the "Clear"-Button ("Leeren" in german, don´t know the exact word in the english version) gets disabled.
Note: It gets re-enabled if you then click in the filter-textfield.
Note: It gets re-enabled if you then click in the filter-textfield.
Code modification/commit
from ansgar.becker,
9 years ago,
revision 4413
Fix disabled "clear" button after adding AND filter in data tab. See http://www.heidisql.com/forum.php?t=12805#p12807
Please login to leave a reply, or register at first.