I want to order the result by id in descending order and then LIMIT the number of rows obtained based on a @condition
ORDER BY id DESC
IF @condition is TRUE THEN LIMIT 1
ELSE nothing
END IF
You could use CASE
:
ORDER BY id DESC
LIMIT CASE WHEN @condition THEN 1 END;
DBFiddle Demo
LIMIT NULL
is the same as omitting the LIMIT clause
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With