Neo4j: Does 'NOT CONTAINS' exist in Neo4j?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
-1
Do you know if exists 'not contains' in Neo4j ?
For example:
LOAD CSV WITH HEADERS FROM 'file:///animal.csv' as a fieldterminator "|"
match (b:Animals{animal:a.type})
where not a.type contains 'x' or not a.type contains 'abc'
set b.type=a.type
Unfortunately in this way the code doesn't work.
neo4j cypher
edited Nov 27 '18 at 2:29
cybersam
41k53353
asked Nov 26 '18 at 14:41
rafraf
446
add a comment |
-1
Do you know if exists 'not contains' in Neo4j ?
For example:
LOAD CSV WITH HEADERS FROM 'file:///animal.csv' as a fieldterminator "|"
match (b:Animals{animal:a.type})
where not a.type contains 'x' or not a.type contains 'abc'
set b.type=a.type
Unfortunately in this way the code doesn't work.
neo4j cypher
edited Nov 27 '18 at 2:29
cybersam
41k53353
asked Nov 26 '18 at 14:41
rafraf
446
no something similar at 'not like'
– raf
Nov 26 '18 at 14:50
Why do you say that your query is not working ?
– logisima
Nov 26 '18 at 15:05
In this way even when I have the 'x' value the set is executed
– raf
Nov 26 '18 at 16:24
case sensitivity? or parenthesis. I would also move the WHERE before the MATCHWITH a WHERE ...
– Michael Hunger
Nov 26 '18 at 16:40
add a comment |
-1
-1
-1
Do you know if exists 'not contains' in Neo4j ?
For example:
LOAD CSV WITH HEADERS FROM 'file:///animal.csv' as a fieldterminator "|"
match (b:Animals{animal:a.type})
where not a.type contains 'x' or not a.type contains 'abc'
set b.type=a.type
Unfortunately in this way the code doesn't work.
neo4j cypher
edited Nov 27 '18 at 2:29
cybersam
41k53353
asked Nov 26 '18 at 14:41
rafraf
446
Do you know if exists 'not contains' in Neo4j ?
For example:
LOAD CSV WITH HEADERS FROM 'file:///animal.csv' as a fieldterminator "|"
match (b:Animals{animal:a.type})
where not a.type contains 'x' or not a.type contains 'abc'
set b.type=a.type
Unfortunately in this way the code doesn't work.
neo4j cypher
neo4j cypher
edited Nov 27 '18 at 2:29
cybersam
41k53353
asked Nov 26 '18 at 14:41
rafraf
446
edited Nov 27 '18 at 2:29
cybersam
41k53353
asked Nov 26 '18 at 14:41
rafraf
446
edited Nov 27 '18 at 2:29
cybersam
41k53353
edited Nov 27 '18 at 2:29
cybersam
41k53353
edited Nov 27 '18 at 2:29
cybersam
41k53353
41k53353
asked Nov 26 '18 at 14:41
rafraf
446
asked Nov 26 '18 at 14:41
rafraf
446
asked Nov 26 '18 at 14:41
rafraf
446
446
no something similar at 'not like'
– raf
Nov 26 '18 at 14:50
Why do you say that your query is not working ?
– logisima
Nov 26 '18 at 15:05
In this way even when I have the 'x' value the set is executed
– raf
Nov 26 '18 at 16:24
case sensitivity? or parenthesis. I would also move the WHERE before the MATCHWITH a WHERE ...
– Michael Hunger
Nov 26 '18 at 16:40
add a comment |
no something similar at 'not like'
– raf
Nov 26 '18 at 14:50
Why do you say that your query is not working ?
– logisima
Nov 26 '18 at 15:05
In this way even when I have the 'x' value the set is executed
– raf
Nov 26 '18 at 16:24
case sensitivity? or parenthesis. I would also move the WHERE before the MATCHWITH a WHERE ...
– Michael Hunger
Nov 26 '18 at 16:40
no something similar at 'not like'
– raf
Nov 26 '18 at 14:50
no something similar at 'not like'
– raf
Nov 26 '18 at 14:50
Why do you say that your query is not working ?
– logisima
Nov 26 '18 at 15:05
Why do you say that your query is not working ?
– logisima
Nov 26 '18 at 15:05
In this way even when I have the 'x' value the set is executed
– raf
Nov 26 '18 at 16:24
In this way even when I have the 'x' value the set is executed
– raf
Nov 26 '18 at 16:24
case sensitivity? or parenthesis. I would also move the WHERE before the MATCH
WITH a WHERE ... – Michael Hunger
Nov 26 '18 at 16:40
case sensitivity? or parenthesis. I would also move the WHERE before the MATCH
WITH a WHERE ... – Michael Hunger
Nov 26 '18 at 16:40
add a comment |
1 Answer
1
active
oldest
votes
2
Note that contains is case sensitive
I would also move the WHERE before the match, it's cheaper there
LOAD CSV WITH HEADERS FROM 'file:///animal.csv' as a fieldterminator "|"
WITH a where (not (a.type contains 'x')) or (not (a.type contains 'abc'))
match (b:Animals{animal:a.type})
set b.type=a.type
Are you also sure you want an OR there and not an AND ?
answered Nov 26 '18 at 16:41
Michael HungerMichael Hunger
36.9k33863
Note that toLower(str) can be used to make it case-insensitive. neo4j.com/docs/developer-manual/current/cypher/functions/string/…
– Tezra
Nov 27 '18 at 15:26
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53483497%2fneo4j-does-not-contains-exist-in-neo4j%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
2
Note that contains is case sensitive
I would also move the WHERE before the match, it's cheaper there
LOAD CSV WITH HEADERS FROM 'file:///animal.csv' as a fieldterminator "|"
WITH a where (not (a.type contains 'x')) or (not (a.type contains 'abc'))
match (b:Animals{animal:a.type})
set b.type=a.type
Are you also sure you want an OR there and not an AND ?
answered Nov 26 '18 at 16:41
Michael HungerMichael Hunger
36.9k33863
Note that toLower(str) can be used to make it case-insensitive. neo4j.com/docs/developer-manual/current/cypher/functions/string/…
– Tezra
Nov 27 '18 at 15:26
add a comment |
2
Note that contains is case sensitive
I would also move the WHERE before the match, it's cheaper there
LOAD CSV WITH HEADERS FROM 'file:///animal.csv' as a fieldterminator "|"
WITH a where (not (a.type contains 'x')) or (not (a.type contains 'abc'))
match (b:Animals{animal:a.type})
set b.type=a.type
Are you also sure you want an OR there and not an AND ?
answered Nov 26 '18 at 16:41
Michael HungerMichael Hunger
36.9k33863
Note that toLower(str) can be used to make it case-insensitive. neo4j.com/docs/developer-manual/current/cypher/functions/string/…
– Tezra
Nov 27 '18 at 15:26
add a comment |
2
2
2
Note that contains is case sensitive
I would also move the WHERE before the match, it's cheaper there
LOAD CSV WITH HEADERS FROM 'file:///animal.csv' as a fieldterminator "|"
WITH a where (not (a.type contains 'x')) or (not (a.type contains 'abc'))
match (b:Animals{animal:a.type})
set b.type=a.type
Are you also sure you want an OR there and not an AND ?
answered Nov 26 '18 at 16:41
Michael HungerMichael Hunger
36.9k33863
Note that contains is case sensitive
I would also move the WHERE before the match, it's cheaper there
LOAD CSV WITH HEADERS FROM 'file:///animal.csv' as a fieldterminator "|"
WITH a where (not (a.type contains 'x')) or (not (a.type contains 'abc'))
match (b:Animals{animal:a.type})
set b.type=a.type
Are you also sure you want an OR there and not an AND ?
answered Nov 26 '18 at 16:41
Michael HungerMichael Hunger
36.9k33863
answered Nov 26 '18 at 16:41
Michael HungerMichael Hunger
36.9k33863
answered Nov 26 '18 at 16:41
Michael HungerMichael Hunger
36.9k33863
answered Nov 26 '18 at 16:41
Michael HungerMichael Hunger
36.9k33863
36.9k33863
Note that toLower(str) can be used to make it case-insensitive. neo4j.com/docs/developer-manual/current/cypher/functions/string/…
– Tezra
Nov 27 '18 at 15:26
add a comment |
Note that toLower(str) can be used to make it case-insensitive. neo4j.com/docs/developer-manual/current/cypher/functions/string/…
– Tezra
Nov 27 '18 at 15:26
Note that toLower(str) can be used to make it case-insensitive. neo4j.com/docs/developer-manual/current/cypher/functions/string/…
– Tezra
Nov 27 '18 at 15:26
Note that toLower(str) can be used to make it case-insensitive. neo4j.com/docs/developer-manual/current/cypher/functions/string/…
– Tezra
Nov 27 '18 at 15:26
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53483497%2fneo4j-does-not-contains-exist-in-neo4j%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
no something similar at 'not like'
– raf
Nov 26 '18 at 14:50
Why do you say that your query is not working ?
– logisima
Nov 26 '18 at 15:05
In this way even when I have the 'x' value the set is executed
– raf
Nov 26 '18 at 16:24
case sensitivity? or parenthesis. I would also move the WHERE before the MATCH
WITH a WHERE ...– Michael Hunger
Nov 26 '18 at 16:40