Public snipts » robertbanh's snipts » Use found_rows() in MySQL

• // use found_rows() as a sql function
  mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
      -> WHERE id > 100 LIMIT 10;
  mysql> SELECT FOUND_ROWS();
  

  sql

  1

  // use found_rows() as a sql function
  mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
      -> WHERE id > 100 LIMIT 10;
  mysql> SELECT FOUND_ROWS();
  

  copy | embed

0 Comments