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!
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
3109547
from ansgar.becker,
12 years ago,
revision 8.0.0.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.