Table filter by exact name

[expired user #12265]'s profile image [expired user #12265] posted 5 years ago in General Permalink

Firstly, let me start off by saying that I've used a bunch of SQL clients and HeidiSQL is my absolute favorite so far!

I love the table filter feature. Is there a way to filter by exact name match? For example, if I have 3 tables:

  1. Person
  2. PersonPhone
  3. PersonAddress If I type Person in the table filter, all three will show up because it matches (this can be difficult when we many tables with a substring that is itself a table name like 'User'). But, is there a way to limit the results to just 'Person' because it matches exactly/completely? If it's not already available, I'd like to request that as a new feature. May be if I search using person (enclosed in stars or quotes etc), the exact and complete match will be displayed?
ansgar's profile image ansgar posted 5 years ago Permalink

Yes, of course - the filter supports regular expressions. Use left and right ending qualifier:

^Person$

Or even have multiple exact matches at once:

^(Person|PersonPhone)$

^Person(Phone)?$

[expired user #12265]'s profile image [expired user #12265] posted 5 years ago Permalink

This is amazing! Thank you so much.

Please login to leave a reply, or register at first.