Question

SELECT `p`.`name`, `f`.*
        FROM `players` `p`, `folks` `f`
        WHERE `p`.`id` = `f`.`guid` 
        AND `f`.`deleted` = 0
        AND `first` = {$id} 
        AND `text` LIKE ?
        LIMIT 10

您可以在此看到Im使用LIMIT的条件。我需要总结所有成果,而没有麻省理工学院的同意。

我先尝试使用:FOUND_ROWS();,但我却在使用方面遇到问题,因为它没有把所有结果退回到任何地方。

Answer 1

The following should do :) Important is the SQL_CALC_FOUND_ROWS, otherwise FOUND_ROWS() won t work!

SELECT SQL_CALC_FOUND_ROWS `p`.`name`, `f`.*
    FROM `players` `p`, `folks` `f`
    WHERE `p`.`id` = `f`.`guid` 
    AND `f`.`deleted` = 0
    AND `first` = {$id} 
    AND `text` LIKE ?
    LIMIT 10


SELECT FOUND_ROWS();

友情链接