zitu4life Posted May 7, 2020 Share Posted May 7, 2020 (edited) Hello there I have over 60 clients that I want to move them to a client group named COVID. I know I could spent 30-45 min doing it One by One editing each client profile (actually, not me...a company staff). Is there I way to do it using phpMyAdmin on less time. How? Edited May 7, 2020 by zitu4life 0 Quote Link to comment Share on other sites More sharing options...
baymax Posted May 7, 2020 Share Posted May 7, 2020 (edited) maybe this query if all 60 clients are in the same group currently. UPDATE tblclients SET groupid='new-group-ID' WHERE groupid='current-group-ID'; Replace the parts in green. Edited May 7, 2020 by baymax 3 Quote Link to comment Share on other sites More sharing options...
zitu4life Posted May 7, 2020 Author Share Posted May 7, 2020 (edited) They are not on same gruop curently, but they have One thing equal, they all have e-mail from hotmail.com So I want to move all clients with e-mail ending @hotmail.com to new group. Edited May 7, 2020 by zitu4life 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted May 7, 2020 Share Posted May 7, 2020 2 hours ago, zitu4life said: So I want to move all clients with e-mail ending @hotmail.com to new group. then you take @baymax's query and change the where statement... UPDATE tblclients SET groupid='new-group-ID' WHERE email LIKE '%@hotmail.com'; 3 Quote Link to comment Share on other sites More sharing options...
zitu4life Posted May 7, 2020 Author Share Posted May 7, 2020 It works! Many thanks, so now I can focus on other tasks ☺️ 0 Quote Link to comment Share on other sites More sharing options...
baymax Posted May 8, 2020 Share Posted May 8, 2020 I learned a lot from Brian as well 😉 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.