I'm trying to perform a full-text search using a regex, but I cannot get to the right syntax or get the expected results.
Let's say I have a database with persons, a full text index on the name and I want to query users by name using a regex to find the persons whose name begins with michael j. I expect to get michael jones, michael johnson, michael jonas...
I am trying to write a query like this:
CALL db.index.fulltext.queryNodes('person_name_fulltext', '/michael j.*/') YIELD node as person, score RETURN person, score
But I don't get any results.
Any ideas on what am I doing wrong?
- Neo4j browser version: 4.3.1
- Neo4j Server version: 4.2.4 (community)