Fermé

Need help with query

Hello,

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:

id

email

date_registered

date_of_birth

last_signup

newsletter

Can you help?

Compétences : MySQL, PHP, WordPress

Voir plus : named query, info youtube users, sql query help, phpscheduleit custom fields users, simple captcha need, ing progect oil need find info oil, add info fields products list oscommerce, add info fields products list, number users registered user can invite wordpress, simple scriptprogram need created, getafreelancer message sql query help needed

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #8533688

37 freelance ont fait une offre moyenne de 23 $ pour ce travail

rajeshsonisl

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 [url removed, login to view] Plus

19 $ USD en 1 jour
(696 Commentaires)
7.8
evgendob

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.

54 $ USD en 1 jour
(343 Commentaires)
7.6
jDevAndDesign

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

20 $ USD en 1 jour
(132 Commentaires)
6.7
Meagan26

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

54 $ USD en 1 jour
(143 Commentaires)
6.6
VnBestSolutions

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

54 $ USD en 1 jour
(98 Commentaires)
6.4
ibbuzz

A proposal has not yet been provided

24 $ USD en 1 jour
(83 Commentaires)
5.7
mmoreyra

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

15 $ USD en 1 jour
(16 Commentaires)
5.6
webstruction

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

30 $ USD en 0 jours
(37 Commentaires)
5.4
danale72

Yes I can help All the best Alexei

20 $ USD en 3 jours
(55 Commentaires)
5.5
woksepp

Hello! I got a query ready for you, hit me up in the chat please! Thanks! ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

20 $ USD en 0 jours
(27 Commentaires)
4.9
SEOSEARCHTEAM

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

35 $ USD en 1 jour
(15 Commentaires)
4.7
cipvtl

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

20 $ USD en 0 jours
(12 Commentaires)
4.4
tranquy102014

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: ++ [url removed, login to view] (Cakephp website) ++ http://www.dive-a Plus

20 $ USD en 1 jour
(11 Commentaires)
4.5
mohamedmssouda

Hello Sir I am expert database administrator ,I wish you give me this opportunity and I will start immediately with the best quality with the lowest price

18 $ USD en 1 jour
(22 Commentaires)
4.1
farjadtahir

Hi, Hope you are fine. I am offering my services for this task. Please PM me so that we can start working right away.

35 $ USD en 1 jour
(19 Commentaires)
4.0
ARKSolution2015

Hello sir! I will do it for you.I am new here and looking for opportunities to excel in this [url removed, login to view] me a chance to prove my self. Thank you

24 $ USD en 1 jour
(23 Commentaires)
4.1
vinaysinghh

I am sql expert certified by Oracle corporation and I can give u solution in a minute

15 $ USD en 1 jour
(4 Commentaires)
3.7
kienngd

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

15 $ USD en 1 jour
(8 Commentaires)
3.4
baguswah

Hello, you just need the query to select the duplicated id right? I can give you the query right away.

15 $ USD en 1 jour
(3 Commentaires)
2.5
deescorp

A proposal has not yet been provided

25 $ USD en 1 jour
(4 Commentaires)
2.8