Table filter by exact name

vbyreddy posted 3 weeks ago in General

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 posted 3 weeks ago

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)?$

vbyreddy posted 3 weeks ago

This is amazing! Thank you so much.

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