mysql选择要从带有多个WHERE子句的单表中选择查询

Question

对于这个基本的查询问题，我对数据库查询感到很抱歉。提前谢谢你。

table called "neuron"  
columns in "neuron" called "neuron_id", "neuron_name" + others (not relevant here)

neuron_id是每个neuron_name的唯一标识符；

假设有5个条目，因此

neuron_id = 1,2,3,4,5及相应的

neuron_name = a，b，c，d，e

我想为选择的neuron_id生成一个包含neuron_name的列表。下面的查询不适用于我。

select neuron_id, neuron_name  
from neuron  
where neuron_name = "a" or "c" or "e"

我希望有以下几点

1,a  
3,c  
5,e

但是上面的查询只会弹出。

1,a

Answer 1

试试这个：

select neuron_id, neuron_name  
from neuron  
where neuron_name = "a" or neuron_name = "c" or neuron_name = "e"

编辑：

来自yper多维数据集的解决方案在语义上更正确。

select neuron_id, neuron_name  
from neuron  
where neuron_name IN ('a', 'c', 'e')