How to search for substring in global search and module filter?

In SuiteCRM 8.4.2, I am trying to search for a string that is contained in a certain field in a module filter, but I only obtain matches that “start with” the entered value. The same happens in the global search (using basic search).

Reviewing the WHERE clauses processed by the search I find that they are generated like this:
contacts.first_name like ‘titulcia%’,contacts.last_name like ‘titulcia%’, …

Is there a way to force a search that uses “like ‘%titulcia%’” instead?

Thanks.

I just tested the online demo and it looks like you can still use the % symbol as a wildcard before your query.

1 Like

Never occurred to me that you can use SQL wildcards directly in the search field.
Strange, but I can work with that.

Thanks for the input.