mysql - SQL : how to select different rows where values are equal to an set of values?

Question

是否可以在 SQL 中实现类似的功能？

SELECT * FROM `services` WHERE servide_id = ('wifi','pulizia','parking','ombrellone','driver','colazione') AND active = 1

例如我有一个表:

service   |price   |active
wifi       €60      0
park       €20      1
option     €30      1
another    €40      1

查询必须执行如下操作:

1) SELECT * FROM service
2) loop through 'service' column and select WHERE service is = to any value on array
3) check if active is = 1

我想要什么？

query:
    SELECT * FROM services WHERE service = ('wifi','park') AND active = 1

result:
    service   |price   |active
    park       €20      1

感谢您的帮助，我刚刚开始使用 SQL :D

Answer 1

您需要使用 SQL IN运算符过滤多个值。

所以你的查询应该是:

SELECT * 
FROM `services` 
WHERE servide IN ('wifi','pulizia','parking','ombrellone','driver','colazione') AND active = 1