使用sprintf（）和格式符号查询问题

Question

I am trying to make query using sprintf() and format symbols but it is not working

sprintf('SELECT pk_i_id FROM %st_item WHERE s_contact_email IN %s ORDER BY dt_pub_date LIMIT 0, %d', DB_TABLE_PREFIX, $email, $countOfItems )

here

DB_TABLE_PREFIX = "ww_";
$email = "[e-mail], [e-mail], [e-mail]";
$countOfItems = 5;

Answer 1

use this format to search in multiple options : $email = "('email1', 'email2', 'email3')";