LetoDMS Community Forum
Partial Search using LIKE - Printable Version

+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: Technical Support (https://community.letodms.com/forumdisplay.php?fid=10)
+--- Thread: Partial Search using LIKE (/showthread.php?tid=388)



Partial Search using LIKE - dgbaker - 11-08-2011

Hi -

With the search function is there a way to allow for partial hits? For example: The document name is BugsBunny and when search for Bun can it come back with BugsBunny.

It seems the search must be exact word and not using a LIKE on the query - %bun%

Thanks
David


RE: Partial Search using LIKE - steinm - 11-09-2011

(11-08-2011, 01:07 AM)dgbaker Wrote: Hi -

With the search function is there a way to allow for partial hits? For example: The document name is BugsBunny and when search for Bun can it come back with BugsBunny.

It seems the search must be exact word and not using a LIKE on the query - %bun%

The regular database search uses LIKE, but the full text search doesn't. The full text search doesn't use the database at all.

Uwe


RE: Partial Search using LIKE - dgbaker - 11-09-2011

(11-09-2011, 12:06 AM)steinm Wrote:
(11-08-2011, 01:07 AM)dgbaker Wrote: Hi -

With the search function is there a way to allow for partial hits? For example: The document name is BugsBunny and when search for Bun can it come back with BugsBunny.

It seems the search must be exact word and not using a LIKE on the query - %bun%

The regular database search uses LIKE, but the full text search doesn't. The full text search doesn't use the database at all.

Uwe

Hi Uwe, thanks for the information. I will take a look a Lucene to see what I can do then. Thanks.