This is an archived copy of the forum for reference purposes

Prepared Statement with LIKE

posted by darren 8 years ago

Hi Guys,

Just wondering how do i go about using the prepared statment with like?

LIKE %s

Im currently doing it like this which appears to work but im not sure if its the right way or even safe?

$db->query($statement, $info, "%{$node}%");

Tried escaping the placed holders with
%%s
% but obvious it aint correct.

Thanks,

Darren