Wildcard in Multi Column Filter?

Hello,

is it possible to use the multi column filter with wildcards? I am running a Maria DB (SQL).

E.G.: I would like to enter a filter like "Hmburg" to get "Hamburg" and "Homburg". But "" as well as "%" are not accepted as wildcards.

Thank you.

Reinald

The multi column filter generator is not really suitable for generating custom wildcard filters. It is meant for entering simple text which then gets wrapped with the percent wildcard character. Note there is also the underline wildcard character, meant for any single character. But even when using an underline in the multi column filter box, it's then escaped by HeidiSQL so it's recognized as a normal character by the server then:

So you need to enter your filter by hand in the filter editor instead:

city LIKE '%H_mburg%'