douwendu2460 2014-09-29 07:52
浏览 154
已采纳

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

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.

  • 写回答

1条回答 默认 最新

  • dongqixian8474 2014-09-29 08:11
    关注
    =~ '(?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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥50 汇编语言除法溢出问题
  • ¥65 C++实现删除N个数据列表共有的元素
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波