CODEWITHSUNDEEP
phpmysqldatabaseexport
Waftrue A.
Waftrue A.

Reputation: 13

Selective export from MySQL database

I've got a database called Members, people would register online entering their fullname, email address, phone number, etc. I made a hidden form where it would set random 4 digit unique number and register it with their data, then I send it via email. People would use these unique IDs to enter an event, only 80% came. I collected the IDs, now I have a list of IDs that belongs to the people that came to the event, I want to export all the rows of people who came using their IDs. Example: For every row that include number: 4293, 1932, 9382 = export. Is there's a way to do this in MySQL?

Upvotes: 0

Views: 54

Answers (1)

Wouter
Wouter

Reputation: 1353

Following query should do the trick

select fullname from members where ID in (4293, 1932, 9382)

Upvotes: 1

Related Questions