I have probably an easy question which keeps my mind bugging for some days now...
I'm trying to put the following SELECT statements into 1 multi SELECT statement, PHP/MYSQL.
SELECT * FROM myTable1
SELECT * FROM myTable2
SELECT * FROM myTable3 ORDER BY RAND() LIMIT 1
SELECT row1, row2 FROM myTable4 ORDER BY id DESC LIMIT 4
I tried UNION or UNION ALL but that doesn't work because all MYSQL tables are different in row quantity.