Check movie titles
Write and execute a query to return all Movie titles in the graph that have a title that begins with "Life is". There may be titles that do not adhere to capitalization as such so you must ensure that all titles will match. That is, it will retrieve any case of the string, such as "Life is", "LIFE IS", "life is", "Life Is".
How many Movie nodes are returned?
-
✓ 4
Hint
You can use toLower() or toUpper() to test against "life is".
Once you have entered the answer, click the Try Again button below to continue.
Solution
You can run the following query to find the answer:
MATCH (m:Movie)
WHERE toUpper(m.title) STARTS WITH 'LIFE IS'
RETURN m.titleHow many titles does it return?
Once you have entered the answer, click the Try Again button below to continue.
Summary
In this challenge, you wrote and executed a query that will find property values, regardless of their case.
In the next challenge, you will answer another question.