Prepare statement for like?

Question

PHP

Hello everyone, there was a problem with preparing an expression for SQL LIKE ..
There is a query like:

prepare...('SELECT * FROM table WHERE field LIKE '%:like%' ...);
и тут же делаю такой бинд:
$bind['like'] = $myVar

а массив $bind передаю в $pdo->execute($bind)

But it doesn’t find anything, although there are lines, I do it without Prepare Statement: it finds everything. In what an essence - How to prepare correctly expression for LIKE SQL?
$pdo->prepare(' SELECT ... LIKE '%text%'..);

Answer 1

This is a feature of prepared expressions. It should be like this:

prepare...('SELECT * FROM table WHERE field LIKE :like ...');
$bind['like'] = '%' . $myVar . '%';

Answer 2

I didn’t work closely with PostGRE, but from experience with other DBMS, it should somehow turn out like this: field
LIKE '%'+:like+'%'
treat them like variables, not constants.