TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Need a "NOT LIKE" Filter

Open rwhirn opened this issue 10 months ago • 0 comments

Please answer the questions below, it helps us to track the issue.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): MySQL 5.7.44

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 272

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

rwhirn avatar Apr 19 '24 17:04 rwhirn