mysql SELECT * FROM product WHERE id_product = relation1,relation2,relation3, : i have 2 table 

prodcut
id_product,price,etc

relation
id,relation1,relation2,relation3,...

i want get any product where id=relation1,...

how to write it in sql ?

SELECT * FROM product WHERE id_product = relation1,relation2,relation3,...