FIND IN SET not working with PDO

Question

I'm having issues with working with mysql's FIND_IN_SET and pdo. This is my code:

$statement = $conn->prepare("SELECT * FROM `artistInfo` WHERE FIND_IN_SET(':array', artistServices)");
$statement->execute(array(':array' => '2'));
while($row = $statement->fetch()){
   echo $row['id'];
   echo "<br />";
}

This doesn't produce any results. Am I doing something wrong? Thanks!

score 0 · Answer 1 · answered Jan 09 '16 at 06:41

$statement = $conn->prepare("SELECT * FROM `artistInfo` WHERE FIND_IN_SET(':array', artistServices)");
$statement->execute(array(:array => '2'));
while($row = $statement->fetch()){
   echo $row['id'];
   echo "<br />";
}

The single quotes surrounding :array is why I wasn't getting any results

FIND IN SET not working with PDO

1 Answers1