i have price column in product table from that column i want get price between like 0-5000 and 5001-1000.is it possible in MySQL?
4999.00
9990.00
10990.00
12990.00
11499.00
17000.00
10990.00
12999.00
14200.00
19499.00
20999.00
i have price column in product table from that column i want get price between like 0-5000 and 5001-1000.is it possible in MySQL?
4999.00
9990.00
10990.00
12990.00
11499.00
17000.00
10990.00
12999.00
14200.00
19499.00
20999.00
Using between:
SELECT *
FROM tab_name
WHERE price BETWEEN 0 and 5000;
-- price BETWEEN 5001 AND 10000