[SOLVED] Can you specify a range in a WHERE IN?

[ballhogjoni]

Can you do this?

 

WHERE column_name IN (1-100)

[trq]

Using some simple php, yes.

 

$range = range(1,100);
$sql = "SELECT foo FROM tbl WHERE fld IN ('" . implode("','", $range) . "')";

[JonnoTheDev]

Not that I am aware of unless you created a string from an array in PHP to pass into the IN operator.

Normal operation would be

WHERE column_name >= 1 AND column_name <= 100

 

http://dev.mysql.com/doc/refman/5.0/en/where-optimizations.html

[fenway]

Using some simple php, yes.

 

$range = range(1,100);
$sql = "SELECT foo FROM tbl WHERE fld IN ('" . implode("','", $range) . "')";

Yes, but why not use BETWEEN?