We have a user table that contains an email field. We are going to modify our table so that the email is now unique.
We know that we have duplicate email. What we need is a simple query that will return every id that contains duplicate email.
Our internal staff will then proceed to make a cleanup among these users.
Our table is named user_info and fields are as follow:
Can you help?
36 freelance font une offre moyenne de $23 pour ce travail
Hello! With 98% to 99% completion rate, 850+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page [login to view URL] Plus
Hello. Wordpress dev expert ready to help you with query. I have more 200 good reviews in dev projects, so all will be done on highest level. Please, do not award project until we will clear details.
Hello, I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. I have been working in the field of web Plus
hello i can help you with this please send me mysql/sql access so i can test it online on your db and will pass it to you when it's ready. regards
Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Plus
Hello, I have read your requirements and I am sure I can get it done in an hour tops, I assure you, you will be more than satisfied with my work. pls initiate chat so we can discuss it in detail. Regards, N Plus
SELECT GROUP_CONCAT(id) AS csl_of_id,email FROM user_info GROUP BY email HAVING COUNT(*) >= 2 ORDER BY email If you get this warning: Row .... was cut by GROUP_CONCAT() put this line before the above query: SET Plus
Hello, I'd be glad to help you identifying those id with duplicate emails. I've created a table with the same structure in order to test my query against it before bidding, and I already have a working solution. Plus
Hello sir! I will do it for you.I am new here and looking for opportunities to excel in this [login to view URL] me a chance to prove my self. Thank you
Hello I have been working with PHP for 7 years.I am a PHP programmer from VietNam (GMT +7). I have experience with PHP Some websites I worked for: ++ [login to view URL] (Cakephp website) ++ http://www.dive-a Plus
Hello, Greetings! I have a team of experience developers and a long list of satisfied clients...offering you very cheap rate with sure result...so please give us a chance to start business relation. ==Skill we h Plus
Hello! I got a query ready for you, hit me up in the chat please! Thanks! ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Hello, you just need the query to select the duplicated id right? I can give you the query right away.
Dear sir, please contact me. We will discuss about your requirements. When I understand your requirements I'll do it for you. This is sql run in MySQL for you to use if you want:): select id, email, (select count(*) as Plus
Well I'll give you solution immediately and you can accept my bid if you will. Use following query: select group_concat(id), email, count(*) c from user_info group by email having c > 1; You will get comma sep Plus
HI - I have been working over 8+ years for different industries using technologies like PHP,MYSQL, CURL, MVC, CakePHP and Android. I am very much interested for this job. Can we discuss further? Thanks, Deep Plus
Hi, Hope you are fine. I am offering my services for this task. Please PM me so that we can start working right away.