How to search data using some part of string

Hi, How to search data using some part of string instead of entire string. ex:

i had a string like “nuxeo database here” In Nuxeo Search i need to get result , if i search using either “nuxeo” or “database” .

i tried by using LIKE Operator but that is not working.

please let me know search data.

Thanks

1 votes

1 answers

1700 views

ANSWER



As you guessed, you should use LIKE (or ILIKE). But you then have to use wildcard-character like “%“. So instead of searching with “nuxeo”, you must search with “nuxeo%“. Be aware that “database%” will not find “nuxeo database here”, but “%database%” will. See here for more information.

0 votes