Ads were blocked - no 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 9 months 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 9 months ago Permalink

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


Or even have multiple exact matches at once:



vbyreddy's profile image vbyreddy posted 9 months ago Permalink

This is amazing! Thank you so much.

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