In-query caueses incorrect query(mysql)
Database management in a single PHP file
Brought to you by:
jakubvrana
When searching using IN() and specifying 1,2,3 in the search field, the generated query is incorrect.
Steps to reproduce
CREATE TABLE table3
(
id
int NOT NULL AUTO_INCREMENT PRIMARY KEY,
title
varchar(20) NOT NULL
) COMMENT=''; -- 0.000 s
INSERT INTO table3
(title
) VALUES ('test3'); -- 0.003 s
INSERT INTO table3
(title
) VALUES ('test2'); -- 0.005 s
INSERT INTO table3
(title
) VALUES ('test1'); -- 0.003 s
table3
WHERE id
IN (),2"
This should be already fixed, thanks for the report.