[RESOLVED] mysqli->prepare( WHERE LIKE %?%) ?

[knowj]

Hopefully a simple way round this.

Basic prepared statement with a basic LIKE string comparison the %?% generates an error even when used with single quotes:

$mysqli = new mysqli(etc..., etc..., etc...)
$stmt = $mysqli->prepare("SELECT `a`, `b`, `c` FROM `table`WHERE `a` LIKE %?%");
$stmt->bind_param('s', $string);
$stmt->execute();
//etc....

Thanks in advance

[NogDog]

One solution:

$stmt = $mysqli->prepare("SELECT `a`, `b`, `c` FROM `table`WHERE `a` LIKE CONCAT('%', ?, '%')");

[knowj]

Cheers Nogdog works a treat.