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.

Wildcards in the table filter?

aagha's profile image aagha posted 2 months ago in General Permalink

Is there a way to use wildcards in the table filter?

I have a DB with hundreds of customer tables, many of which have dozens of tables--see the attached.

I'd like a way of querying using a wildcard, so I could do: prod_com_customername*order or prod_com_customername%order

...and that would return for me all the tables that start with "prod_com_customername"" and end with "order"

1 attachment(s):
  • filter
ansgar's profile image ansgar posted 2 months ago Permalink

Even better - the filter supports regular expressions:

  • "prod_com_customername" gives you all tables containing that string
  • "^prod_com_customername" : starts with that string
  • "prod_com_customername(_acconfig|_offer)" : contains acconfig or offer after that
  • "thing$" : ends with thing
  • ... endless more possibilities
aagha's profile image aagha posted 2 months ago Permalink

Fantastic! thanks @ansgar!

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