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;
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.