Query that find values that have a word in any position

0 votes

I want to create a query like:

WHERE name LIKE '%ui%'

To find any values that have "ui" in any position of the word, for example:

L'ui's or adoq'ui'n

is this possible to do?

I tried with "Operator::LIKE" but this, only find word that match from the start.

Please, regards.

asked Mar 13 in PHP by Luis Alquinta (10 points)
edited Mar 14 by Luis Alquinta

1 Answer

0 votes
Hi Luis,

Could you please explain the issue in detail, it will help us to provide better support to you.

Regards,

Priyanka Singh

App42 Team
answered Mar 14 by priyanka.singh (166 points)
how about now?
Download Widgets
Welcome to ShepHertz Product line forum, where you can ask questions and receive answers from the community. You can also reach out to us on support@shephertz.com
...