How can i select multiple rows by a certain ids in sql

Question

I need to select multiple rows in db (using MYSQL). I create the following query by iterating over array of ids:

$ids = array(1,2);
$idq = array();
$q = "SELECT * FROM table_name WHERE ";
foreach($ids as $id)
{
    $idq[] = "`ID` = '" . $id . "'";
}

$q .= implode(" AND ", $idq);

SELECT * FROM table_name WHERE `ID` = '1' AND `ID` = '2'

For some reason it doesn't seem to work:

The above won't work. Is there a better way?

When I do:

`SELECT * FROM table_name WHERE `ID` = '1'`

It works fine but when I add the AND ID = '2' it won't work at all.

Dan · Accepted Answer · 2014-06-11 14:59:32Z

2

Use WHERE IN

SELECT * FROM table_name WHEREIDIN ('1', '2')

answered Jun 11, 2014 at 14:59

Dan

9,4885 gold badges44 silver badges76 bronze badges

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

Comments

crthompson · Accepted Answer · 2014-06-11 15:05:45Z

2

SELECT * FROM table_name WHERE `ID` = '1' AND `ID` = '2'

The ID cannot be 1 and 2 at the same time. You should use OR.

SELECT * FROM table_name WHERE `ID` = '1' OR `ID` = '2'

or

SELECT * FROM table_name WHERE `ID` IN (1,2,...)

edited Jun 11, 2014 at 15:05

crthompson

15.9k6 gold badges64 silver badges87 bronze badges

answered Jun 11, 2014 at 15:03

Fabio

1161 bronze badge

Comments

Fabio · Accepted Answer · 2019-05-17 23:04:34Z

0

SELECT * FROM table_name WHERE ID = '1' AND ID = '2'

You are saying: I want to go to the beach and to skiing at 5pm of the same day. Result: not possible. You can either go to the beach or to skiing. so your query should look like:

SELECT * FROM table_name WHERE ID = '1' OR ID = '2' or SELECT * FROM table_name WHERE ID in (1,2)

answered May 17, 2019 at 23:04

Fabio

1161 bronze badge

Collectives™ on Stack Overflow

How can i select multiple rows by a certain ids in sql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related