How to make all db records start with a specific value?











up vote
0
down vote

favorite












I have a SQL DB that contains a real data for clients,
what I want to do is to make a SQL update query to update the phone column in clients table and make all its records start with '966'



can any one help me make this query?










share|improve this question


























    up vote
    0
    down vote

    favorite












    I have a SQL DB that contains a real data for clients,
    what I want to do is to make a SQL update query to update the phone column in clients table and make all its records start with '966'



    can any one help me make this query?










    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I have a SQL DB that contains a real data for clients,
      what I want to do is to make a SQL update query to update the phone column in clients table and make all its records start with '966'



      can any one help me make this query?










      share|improve this question













      I have a SQL DB that contains a real data for clients,
      what I want to do is to make a SQL update query to update the phone column in clients table and make all its records start with '966'



      can any one help me make this query?







      mysql sql






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 11 at 14:47









      Norhan Foda

      277




      277
























          2 Answers
          2






          active

          oldest

          votes

















          up vote
          3
          down vote













          Presumably, it would be something like this:



          update t
          set phone = concat('966', phone)
          where phone not like '966%';





          share|improve this answer






























            up vote
            1
            down vote













            update t
            set phone = concat('966', phone)
            where substr(phone,1,3)!=966






            share|improve this answer





















              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',
              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%2f53249851%2fhow-to-make-all-db-records-start-with-a-specific-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








              up vote
              3
              down vote













              Presumably, it would be something like this:



              update t
              set phone = concat('966', phone)
              where phone not like '966%';





              share|improve this answer



























                up vote
                3
                down vote













                Presumably, it would be something like this:



                update t
                set phone = concat('966', phone)
                where phone not like '966%';





                share|improve this answer

























                  up vote
                  3
                  down vote










                  up vote
                  3
                  down vote









                  Presumably, it would be something like this:



                  update t
                  set phone = concat('966', phone)
                  where phone not like '966%';





                  share|improve this answer














                  Presumably, it would be something like this:



                  update t
                  set phone = concat('966', phone)
                  where phone not like '966%';






                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited Nov 11 at 15:10

























                  answered Nov 11 at 14:48









                  Gordon Linoff

                  752k34286394




                  752k34286394
























                      up vote
                      1
                      down vote













                      update t
                      set phone = concat('966', phone)
                      where substr(phone,1,3)!=966






                      share|improve this answer

























                        up vote
                        1
                        down vote













                        update t
                        set phone = concat('966', phone)
                        where substr(phone,1,3)!=966






                        share|improve this answer























                          up vote
                          1
                          down vote










                          up vote
                          1
                          down vote









                          update t
                          set phone = concat('966', phone)
                          where substr(phone,1,3)!=966






                          share|improve this answer












                          update t
                          set phone = concat('966', phone)
                          where substr(phone,1,3)!=966







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered Nov 11 at 15:40









                          saravanatn

                          43627




                          43627






























                              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.





                              Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                              Please pay close attention to the following guidance:


                              • 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%2f53249851%2fhow-to-make-all-db-records-start-with-a-specific-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

                              Florida Star v. B. J. F.

                              Danny Elfman

                              Retrieve a Users Dashboard in Tumblr with R and TumblR. Oauth Issues