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.