fetch specific columns from MySQL

Question

I am trying to fetch specific columns from a table using phpmyadmin but it gives me sytanx error

my statement:

SELECT * FROM `node_revisions` WHERE `nid` =4,5,8,20;

Jens · Accepted Answer · 2017-06-01 13:13:41Z

1

You mean specific rows (not columns). You have to use in:

SELECT * FROM `node_revisions` WHERE `nid` in (4,5,8,20);

or AND concatinated where clause:

SELECT * FROM `node_revisions` WHERE `nid` =4 AND `nid` =5 AND `nid` =8 AND `nid` =20;

answered Jun 1, 2017 at 13:11

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fast as lightning hehe :)

Neil · Accepted Answer · 2017-06-01 13:11:17Z

0

You probably meant to write:

SELECT * FROM `node_revisions` WHERE `nid` in (4,5,8,20);

Does this help?

answered Jun 1, 2017 at 13:11

Neil

5,79727 silver badges37 bronze badges