Code: Select all
SELECT
UNLESS_IS_EMPTY(subject, '(No Subject)') -- Is there a function that does something like this?
FROM messages
WHERE
...
Moderator: General Moderators
Code: Select all
SELECT
UNLESS_IS_EMPTY(subject, '(No Subject)') -- Is there a function that does something like this?
FROM messages
WHERE
...
Code: Select all
SELECT
IF(subject = '', '(No Subject)', subject) AS title
FROM messages
WHERE
...