mysql执行准备_MYSQL - 准备stmt并执行stmt并添加WHERE和LIKE

这是因为多少？应该等于USING子句之后的参数数量。你也给错了引号？而不是"?"尝试：

PREPARE STMT FROM 'SELECT a, b, c, d, e FROM TABLE_1 WHERE (`a` like "%?%" OR `b` like "%?%" OR `c` like "%?%" OR `d` like "%?%" OR `e` like "%?%") LIMIT ?, ?';

EXECUTE STMT USING @search, @search, @search, @search, @search, @skip, @rows;或尝试

SET @query1 = CONCAT('

SELECT SQL_CALC_FOUND_ROWS a, b, c, d, e

FROM TABLE_1

WHERE (`a` like "%',@search,'%" OR

`b` like "%',@search,'%" OR

`c` like "%',@search,'%" OR

`d` like "%',@search,'%" OR

`e` like "%',@search,'%")

LIMIT ',@skip,', ',@rows,'');

PREPARE stmt FROM @query1;

EXECUTE stmt;

SELECT FOUND_ROWS() AS total_rows;

DEALLOCATE PREPARE stmt;