How to search data using some part of string
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2015 08:03 AM
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 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-12-2015 08:58 AM
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.
