本文介绍了mysql select命令的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
有人可以帮我吗？我想显示字段workstatus = HRD和REASGD的所有数据以及字段Detachment = [Detachment Name]
can someone help me with this? i want to show all data that the field workstatus = HRD and REASGD and the field Detachment = [Detachment Name]
推荐答案
SELECT * FROM tablename WHERE workstatus IN ('HRD', 'REASGD') AND Detachment = 'detachment name'
这篇关于mysql select命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！