如何使用where for mysql和php启动有限的查询 - how to start a limited query using the where for mysql and php?

how to start a limited query using the where for mysql and php?

如何使用where for mysql和php启动有限查询？

例如，下面的查询？？

       $start = 0;
       $range = 10;
       $query = "SELECT column FROM $table LIMIT $start, $range";

但我想做的是从一个特定的列值开始一个Limit$，然后从那里开始增加，就像这样：

                          $start = column_value;

将where子句添加到SQL查询中：

$query = "SELECT column 
              FROM $table 
          WHERE column >= $column_value
          LIMIT $start, $range";

您还需要一个ORDER BY子句。

$query = "SELECT column
FROM $table            
WHERE column > $column_value           
ORDER BY column
LIMIT $start, $range";