Order of word matches
68093Jun 25 2009 — edited Jun 25 2009Hi all
We have a system where we have stored the full name of a person in a column (in addition to columns for firstname, middlename and lastname separately). We want to use Oracle Text to search on persons by full name. Our first attempt was to ignore middle name and do something like:
contains(PE.FULLNAME, 'christian holm', 1) >0
This works fine for people without middlename, but since my name is "Christian Laumand Holm" it wont find me. We then changed it to:
contains(PE.FULLNAME, 'christian and holm', 1) >0
which finds my name, but also someone named "Knud Holm Christian Jensen", which is not what the user expects. The order of the words must match the order of the words in the fullname. Is there any way to solve this problem?
Thanks,
Christian