字符串运算符

    CONTAINS

    1. nebula> MATCH (s:player)-[e:serve]->(t:team) WHERE id(s) == "player101" \
    2.         AND t.name CONTAINS "ets" RETURN s.name, e.start_year, e.end_year, t.name;
    3. +---------------+--------------+------------+-----------+
    4. | s.name        | e.start_year | e.end_year | t.name    |
    5. +---------------+--------------+------------+-----------+
    6. | "Tony Parker" | 2018         | 2019       | "Hornets" |
    7. +---------------+--------------+------------+-----------+
    9. nebula> GO FROM "player101" OVER serve WHERE (STRING)serve.start_year CONTAINS "19" AND \
    10.         $^.player.name CONTAINS "ny" \
    11.         YIELD $^.player.name, serve.start_year, serve.end_year, $$.team.name;
    12. | $^.player.name | serve.start_year | serve.end_year | $$.team.name |
    14. | "Tony Parker"  | 1999             | 2018           | "Spurs"      |
    15. +----------------+------------------+----------------+--------------+
    17. nebula> GO FROM "player101" OVER serve WHERE !($$.team.name CONTAINS "ets") \
    18.         YIELD $^.player.name, serve.start_year, serve.end_year, $$.team.name;
    19. +----------------+------------------+----------------+--------------+
    20. | $^.player.name | serve.start_year | serve.end_year | $$.team.name |
    21. +----------------+------------------+----------------+--------------+
    22. | "Tony Parker"  | 1999             | 2018           | "Spurs"      |
    23. +----------------+------------------+----------------+--------------+

    (NOT) STARTS WITH

    1. nebula> RETURN 'apple' STARTS WITH 'app', 'apple' STARTS WITH 'a', 'apple' STARTS WITH toUpper('a')
    2. +-----------------------------+---------------------------+------------------------------------+
    3. | ("apple" STARTS WITH "app") | ("apple" STARTS WITH "a") | ("apple" STARTS WITH toUpper("a")) |
    4. +-----------------------------+---------------------------+------------------------------------+
    5. | true                        | true                      | false                              |
    6. +-----------------------------+---------------------------+------------------------------------+
    7. nebula> RETURN 'apple' STARTS WITH 'b','apple' NOT STARTS WITH 'app'
    9. | ("apple" STARTS WITH "b") | ("apple" NOT STARTS WITH "app") |
    10. +---------------------------+---------------------------------+
    11. | false                     | false                           |
    12. +---------------------------+---------------------------------+

    正则表达式

    1. nebula> RETURN "384748.39" =~ "\\d+(\\.\\d{2})?";
    2. +----------------------------+
    3. | (384748.39=~\d+(\.\d{2})?) |
    4. +----------------------------+
    5. | true                       |
    6. +----------------------------+
    8. nebula> MATCH (v:player) WHERE v.name =~ 'Tony.*' RETURN v.name;
    9. +---------------+
    10. | v.name        |
    11. +---------------+
    12. | "Tony Parker" |