String Comparison Functions and Operators¶
| Name | Description |
|---|---|
| CONTAINS | Perform case-sensitive inclusion searching in strings |
- CONTAINS
The CONTAINS operator is used to perform case-sensitive matching regardless of location within a string. The CONTAINS operator requires string type in both left and right side.
nebula> GO FROM 107 OVER serve WHERE $$.team.name CONTAINS "riors" \
YIELD $^.player.name, serve.start_year, serve.end_year, $$.team.name;
=====================================================================
| $^.player.name | serve.start_year | serve.end_year | $$.team.name |
=====================================================================
| Aron Baynes | 2001 | 2009 | Warriors |
---------------------------------------------------------------------
nebula> GO FROM 107 OVER serve WHERE $$.team.name CONTAINS "Riors" \
YIELD $^.player.name, serve.start_year, serve.end_year, $$.team.name; -- The follow query returns nothing.
nebula> GO FROM 107 OVER serve WHERE (STRING)serve.start_year CONTAINS "07" && \
$^.player.name CONTAINS "Aron" \
YIELD $^.player.name, serve.start_year, serve.end_year, $$.team.name;
=====================================================================
| $^.player.name | serve.start_year | serve.end_year | $$.team.name |
=====================================================================
| Aron Baynes | 2007 | 2010 | Nuggets |
---------------------------------------------------------------------
nebula> GO FROM 107 OVER serve WHERE !($$.team.name CONTAINS "riors") \
YIELD $^.player.name, serve.start_year, serve.end_year, $$.team.name;
=====================================================================
| $^.player.name | serve.start_year | serve.end_year | $$.team.name |
=====================================================================
| Aron Baynes | 2007 | 2010 | Nuggets |
---------------------------------------------------------------------
Last update: April 8, 2021