Hello everyone. I am trying to construct a search query with Neo4j that will look for recipes with 2 levels of initial node, and then output them by number of time some relationship exist on the recipe node.
My query looks like this now
WHERE n.name CONTAINS "pizza" OR n.content CONTAINS "pizza" OR n.title CONTAINS "pizza" WITH r, count(a) as c return r,c order by c desc
This will return recipes with most matches on top, but i am not satisfied with my results, for example pasta has more connections than 15 minutes pizza recipe. So technically when user type pizza first thing that shows up will be pasta. Is there an
IF statement in CYPHER that i can use to check if name of recipe include search query and return that first?
I think this might be a trivial question, but i just started with GraphDB and everything is pretty new to me.
Thanks for help!