Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Table filter by exact name

vbyreddy's profile image vbyreddy posted 6 months 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's profile image ansgar posted 6 months 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's profile image vbyreddy posted 6 months ago

This is amazing! Thank you so much.

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