duanmeng1862
duanmeng1862
2016-11-10 09:09

从MySQL数据库中选择性导出

已采纳

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?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • dslf46995 dslf46995 5年前

    Following query should do the trick

    select fullname from members where ID in (4293, 1932, 9382)
    
    点赞 评论 复制链接分享

相关推荐