Wed Mar 03, 2010 6:28 pm - How To Get Mysql Between Query
#3226
How To Get Mysql Between Query
today i learned how to send a query to select between values
for example, i have 50 user_id and i want to select only between 25 and 30 so to do that, i can send this query:
$sql = "SELECT user_id FROM mytable WHERE user_id BETWEEN 25 AND 30";
as you can see from this query, we searched for any user_id between the numbers of 25 and 30 so any user_id between those numbers in the mytable it will be selected. so getting and querying your information in you db is easy steps;
does that help?
for example, i have 50 user_id and i want to select only between 25 and 30 so to do that, i can send this query:
$sql = "SELECT user_id FROM mytable WHERE user_id BETWEEN 25 AND 30";
as you can see from this query, we searched for any user_id between the numbers of 25 and 30 so any user_id between those numbers in the mytable it will be selected. so getting and querying your information in you db is easy steps;
does that help?
author: Wallpaperama