BIT型のリテラルだけ、変数に置くのはどうでしょうか。
test.php
$db->exec("SET @val = 0b0011");
$stmt = $db->prepare("UPDATE SET column = @val WHERE id = :id");
$stmt->bindValue(':id', 123);
$stmt->execute();
More than 5 years have passed since last update.
BIT型のリテラルだけ、変数に置くのはどうでしょうか。
$db->exec("SET @val = 0b0011");
$stmt = $db->prepare("UPDATE SET column = @val WHERE id = :id");
$stmt->bindValue(':id', 123);
$stmt->execute();
Register as a new user and use Qiita more conveniently