SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table IV_word ( id1 int (10) AUTO_INCREMENT, id2 int(10) NOT NULL, PRIMARY KEY (id1) ); INSERT INTO IV_word (id2) VALUES (3); INSERT INTO IV_word (id2) VALUES (1); INSERT INTO IV_word (id2) VALUES (2); INSERT INTO IV_word (id2) VALUES (6); SELECT * FROM ( SELECT * FROM `IV_word` WHERE 1=1 ORDER BY (id2) LIMIT 2 ) d ORDER BY RAND() LIMIT 1
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear