How to search numbers in php mysql query?

Question

How would i search for a random number between two numbers by mysql query. This is not a valid mysql command this just for understanding.

$number = 3600;
$aa = 3300;
$bb = 4000;
$query = "Search for the $number between $aa AND $bb";

How would i do this with php and mysql.

GluePear · Accepted Answer · 2015-02-25 13:41:11Z

3

Try

SELECT * FROM `table_name` WHERE `number` BETWEEN '$aa' AND '$bb'

See the manual entry for BETWEEN.

This is just the MySQL query. How you call it in PHP depends on your framework. E.g. you could use PDO.

answered Feb 25, 2015 at 13:41

GluePear

7,77321 gold badges73 silver badges127 bronze badges

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

1 Answer 1