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

Published 20 hours ago • verified publisher icon TablePlus

No filter option for NOT LIKE %

Open rwhirn opened this issue 5 years ago • 2 comments

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

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

  3. The steps to reproduce this issue: I can't create this query: fieldName NOT LIKE 'ONL%'

I can do "Has prefix" and get "LIKE 'ONL%'" and I can do "Contains" to get "LIKE '%ONL%'" or "Not contains" to get NOT LIKE '%ONL%' but I can't do "Not has prefix" or "Not has suffix"

rwhirn avatar Aug 20 '19 22:08 rwhirn

@huyphams I saw the new version you added "NOT CONTAINS" to Find in results. Made me remember this old request.

"Not has prefix" and "Not has suffix" ought to be relatively simple to add to the main Find function. How come this never got added in?

rwhirn avatar Sep 13 '22 20:09 rwhirn

@huyphams What's missing from this list?

=/<> IN/NOT IN IS NULL/IS NOT NULL BETWEEN/NOT BETWEEN Contains/Not Contains LIKE/????? <===== Can I get a "NOT LIKE"????

rwhirn avatar Sep 07 '23 22:09 rwhirn