WHERE IT EXPLODES

Question

How do I make a Where with explode? I have a variable with the values "5100/5101/5102" and so it goes, I wanted to list the posts with the ID of this variable

Answer 1

You can elaborate as follows:

$var = "5100/5101/5102";
$var = str_replace("/", ",", $var);
$consulta = "SELECT * FROM tabela WHERE campo IN ('$var')";

Using the WHERE field IN, you can return the desired id’s according to your database.