Operators in Age

In the article we will talk about different operators in apache age:

String Specific Comparison Operators

Data Setup

Setting up sample data

SELECT * FROM cypher('tutorial', $$ CREATE (:Person {name: 'Talha'}), (:Person {name: 'Usman'}), (:Person {name: 'Irfan'}) $$) AS (result agtype); 

Starts With

The operator performs case sensitive prefix searching on selected strings.

SELECT * FROM cypher('tutorial', $$ MATCH (v:Person) WHERE v.name STARTS WITH "T" RETURN v.name $$) AS (names agtype); 

The above query returns the names of the persons starting with T.

End With

Performs case sensitive suffix searching on selected strings.
Query:

SELECT * FROM cypher('tutorial', $$ MATCH (v:Person) WHERE v.name ENDS WITH "a" RETURN v.name $$) AS (names agtype); 

The above query will return the names of the people ended with a which in this case is 1.

Regular expressions:

Age also supports the use of POSIX regular expressions using the =~ operator.

Basic String Matching:

The =~ operator acts like the = operator when no special characters are provided.

SELECT * FROM cypher('tutorial', $$ MATCH (v:Person) WHERE v.name =~ 'Usman' RETURN v.name $$) AS (names agtype); 

Case insensitive Search:

Adding ?! at the beginning of the string will make case insensitive comparisons.
Query:
The query below performs case insensitive search

SELECT * FROM cypher('graph_name', $$ MATCH (v:Person) WHERE v.name =~ '(?i)USman' RETURN v.name $$) AS (names agtype); 

. Wildcard

. operator acts as a wildcard to match any single character.
Query:
The below query will search for any character in our data

SELECT * FROM cypher('graph_name', $$ MATCH (v:Person) WHERE v.name =~ 'Usm.n' RETURN v.name $$) AS (names agtype); 

The * wildcard

• wildcard see if it matches the zero o more of the previous character. Query:

SELECT * FROM cypher('graph_name', $$ MATCH (v:Person) WHERE v.name =~ 'Talo*a' RETURN v.name $$) AS (names agtype); 

The above query will see whether the character behind * matches then prints the name, else print it by eliminating the o.

The + operator:

The + operator matches to 1 or more the previous character.
Query:

SELECT * FROM cypher('tutorial', $$ MATCH (v:Person) WHERE v.name =~ 'Usm+' RETURN v.name $$) AS (names agtype);