如何在Neo4j中进行精确的单词匹配？

Question

In Neo4j, we can do mysql query "like" with

ex. If node "temp" have column "col" and value "This was in World war 1945";

If we search by "wor"

and where query is

temp.col =~  '(?i).*'. $search_value . '.*'

Then results are coming. But I want results to come only when searched for world with any case change.

How to do exact word match?

i.e. If we search for string then there should be space or no any character at start and end of word.

Answer 1

=~ '(?i).*'. $search_value . '.*'

=~ = Regex search (?i) = case insenstive .* = Match anything $search_value = Your string .* = Match anything

If you want to match whole words, and you want to match the case, and if that whole word can appear mid sentence then you could try:

=~'.*\\b' . $search_value . '\\b.*'

\b is a word boundary matcher.

Update: "\\b" double slashes are required to escaping in for regular expressions.