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
1787 views
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.
 |
Greg Drayon
Member (1.4K) 1 3 5 |
11/12/2015 ( History) |