How can this code convert to correct query? Is it possible?
first i want check if id IN (55,1454,232,444,10999,223) is exists rows. second if not exists get rows by random.
SELECT
id
name
title
FROM
table t
WHERE
id IN (55,1454,232,444,10999,223)
IF count_row(t) == 0 // <-- if for WHERE no result row
SELECT
id
name
title
FROM
table
ORDER BY RAND()
LIMIT 20
Aucun commentaire:
Enregistrer un commentaire