mysql - 如何在此 sql 查询中使用 0-20 之间的范围？

Question

如何在此 SQL 查询中使用 0-20 之间的范围？

  $sql = 'SELECT * FROM t1
          LEFT JOIN t2 ON t2.wid = t1.wid  
          UNION
          SELECT * FROM t1
          RIGHT JOIN t2 ON t2.wid = t1.wid
          limit 0, 20';
  $result = db_query($sql);//->fetchField();

Answer 1

将 LIMIT 传递到您的查询中。你的限制每次都会变化，就像

$sql = 'SELECT * FROM (SELECT * FROM t1
          LEFT JOIN t2 ON t2.wid = t1.wid  
          UNION
          SELECT * FROM t1
          RIGHT JOIN t2 ON t2.wid = t1.wid) AS A LIMIT'.$start.','.$end