php - MySQL LIKE + php sprintf

Question

$test = sprintf("SELECT * FROM `table` WHERE `text` LIKE '%%s%'", mysql_real_escape_string('test'));

echo $test;

输出:

SELECT * FROM `table` WHERE `text` LIKE '%s

但它应该输出:

SELECT * FROM `table` WHERE `text` LIKE '%test%'

Answer 1

... LIKE '%%%s%%'", mysql_real_escape_string('test'));

要打印 % 字符，您需要将其自身转义。因此前两个 %% 将打印 % 字符，而第三个用于类型说明符 %s。最后你还需要一个双 %%。