Apostrophe in a string property value












0















MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;


The apostrophe in "Nancy's" is breaking the statement. is there a way around it?










share|improve this question





























    0















    MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;


    The apostrophe in "Nancy's" is breaking the statement. is there a way around it?










    share|improve this question



























      0












      0








      0








      MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;


      The apostrophe in "Nancy's" is breaking the statement. is there a way around it?










      share|improve this question
















      MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;


      The apostrophe in "Nancy's" is breaking the statement. is there a way around it?







      neo4j cypher






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 15 '18 at 19:31









      cybersam

      40.2k43152




      40.2k43152










      asked Nov 15 '18 at 14:12









      sunil nairsunil nair

      1




      1
























          2 Answers
          2






          active

          oldest

          votes


















          1














          The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"



          Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.



          Last information, if you use query paramters, Neo4j will do it for you.






          share|improve this answer


























          • Thank a ton !! that worked

            – sunil nair
            Nov 15 '18 at 14:29



















          0














          You can try escaping the apostrophe in the name, this way:



          MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;






          share|improve this answer
























          • thank you !! so much

            – sunil nair
            Nov 15 '18 at 14:32











          • If it works, consider accepting it to help future readers

            – gratien asimbahwe
            Nov 15 '18 at 14:34











          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


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53321350%2fapostrophe-in-a-string-property-value%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          2 Answers
          2






          active

          oldest

          votes








          2 Answers
          2






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          1














          The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"



          Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.



          Last information, if you use query paramters, Neo4j will do it for you.






          share|improve this answer


























          • Thank a ton !! that worked

            – sunil nair
            Nov 15 '18 at 14:29
















          1














          The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"



          Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.



          Last information, if you use query paramters, Neo4j will do it for you.






          share|improve this answer


























          • Thank a ton !! that worked

            – sunil nair
            Nov 15 '18 at 14:29














          1












          1








          1







          The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"



          Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.



          Last information, if you use query paramters, Neo4j will do it for you.






          share|improve this answer















          The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"



          Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.



          Last information, if you use query paramters, Neo4j will do it for you.







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 15 '18 at 20:58

























          answered Nov 15 '18 at 14:20









          logisimalogisima

          5,2661927




          5,2661927













          • Thank a ton !! that worked

            – sunil nair
            Nov 15 '18 at 14:29



















          • Thank a ton !! that worked

            – sunil nair
            Nov 15 '18 at 14:29

















          Thank a ton !! that worked

          – sunil nair
          Nov 15 '18 at 14:29





          Thank a ton !! that worked

          – sunil nair
          Nov 15 '18 at 14:29













          0














          You can try escaping the apostrophe in the name, this way:



          MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;






          share|improve this answer
























          • thank you !! so much

            – sunil nair
            Nov 15 '18 at 14:32











          • If it works, consider accepting it to help future readers

            – gratien asimbahwe
            Nov 15 '18 at 14:34
















          0














          You can try escaping the apostrophe in the name, this way:



          MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;






          share|improve this answer
























          • thank you !! so much

            – sunil nair
            Nov 15 '18 at 14:32











          • If it works, consider accepting it to help future readers

            – gratien asimbahwe
            Nov 15 '18 at 14:34














          0












          0








          0







          You can try escaping the apostrophe in the name, this way:



          MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;






          share|improve this answer













          You can try escaping the apostrophe in the name, this way:



          MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 15 '18 at 14:20









          gratien asimbahwegratien asimbahwe

          1,12131123




          1,12131123













          • thank you !! so much

            – sunil nair
            Nov 15 '18 at 14:32











          • If it works, consider accepting it to help future readers

            – gratien asimbahwe
            Nov 15 '18 at 14:34



















          • thank you !! so much

            – sunil nair
            Nov 15 '18 at 14:32











          • If it works, consider accepting it to help future readers

            – gratien asimbahwe
            Nov 15 '18 at 14:34

















          thank you !! so much

          – sunil nair
          Nov 15 '18 at 14:32





          thank you !! so much

          – sunil nair
          Nov 15 '18 at 14:32













          If it works, consider accepting it to help future readers

          – gratien asimbahwe
          Nov 15 '18 at 14:34





          If it works, consider accepting it to help future readers

          – gratien asimbahwe
          Nov 15 '18 at 14:34


















          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














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53321350%2fapostrophe-in-a-string-property-value%23new-answer', 'question_page');
          }
          );

          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







          Popular posts from this blog

          Bressuire

          Vorschmack

          Quarantine