如何使用mysql数据搜索范围

Question

I realize i can use range in the query. Bt what if to dont wanna make another query? I only wanna sort my previous result set.

Is it possible to specify a range for mysql pointer while using mysql_data_seek()?

Eg.

 mysql_data_seek($result, 0-1)

Answer 1

use range in the query.

syntax:

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

example:

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;