如何在mysql中执行此查询? [英] How to do this query in mysql?

问题描述

从其中item_id = $ var;的项目中选择item_name

SELECT item_name from items WHERE item_id = $var;

我尝试过:

$ var = 001 || 002 || 003 || 004;

$var = 001 || 002 || 003 || 004;

$ var = 001 OR 002 OR 003 OR 004;

$var = 001 OR 002 OR 003 OR 004;

$ var = 001或002或003或004;

$var = 001 or 002 or 003 or 004;

但是所有方法都不起作用.

But all do not work.

谢谢，我尝试过，但是只输出1个结果=> 1.

Thanks, i try that, but the output only 1 result => 1.

我想要的是全部输出，即1、2、3和4.意味着，我想从1列中选择多个记录(行)

What I want is to output all, i.e. 1, 2 , 3 and 4.. Means, I want to select multiple records(rows) from 1 column

该怎么做?

推荐答案

SELECT item_name from items WHERE item_id IN (1, 2, 3, 4)

并且由于某些原因，如果item_id是VARCHAR:

And if item_id is a VARCHAR for some reason:

SELECT item_name from items WHERE item_id IN ('001', '002', '003', '004')

这篇关于如何在mysql中执行此查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！