TablePlus-Windows
TablePlus-Windows copied to clipboard
Need a "NOT LIKE" Filter
Please answer the questions below, it helps us to track the issue.
-
Which driver are you using and version of it (Ex: PostgreSQL 10.0): MySQL 5.7.44
-
Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 272
-
The steps to reproduce this issue: I want "ID"s that start with "M" but DON'T start with "M3". Can't filter that. A "NOT LIKE" option would do where I can type my own "%" Otherwise a "NOT" checkbox you could click with "LIKE", "PREFIX" OR "SUFFIX" I tried selecting "not equal" but this is what I got and it didn't work.
-- Current filter --
SELECT * FROM `Xref` WHERE (`ID` LIKE 'M%') AND (`ID` <> 'M3%') ORDER BY `xrefID` LIMIT 1000 OFFSET 0;