CODEWITHSUNDEEP
mysqlsql
Ethan Allen
Ethan Allen

Reputation: 14835

How do I combine MySQL statements with an "IF"?

How do I combine these into one statement using MySQL?

SELECT COUNT(barcode) AS count
FROM movieitemdetails_custom
WHERE username = 'John';

if count is == 0

    SELECT title FROM movieitemdetails WHERE barcode = '12345';

else

    SELECT title FROM movieitemdetails_custom WHERE username = 'John';

end-if

Upvotes: 1

Views: 57

Answers (3)

wchiquito
wchiquito

Reputation: 16559

One option is:

SELECT COALESCE(`mdc`.`title`, `md`.`title`, 'NO TITLE') `title`
FROM (SELECT NULL) der
    LEFT JOIN `movieitemdetails_custom` `mdc` ON `mdc`.`username` = 'John'
    LEFT JOIN `movieitemdetails` `md` ON `md`.`barcodes` = '1234567890';

Upvotes: 0

Ed Gibbs
Ed Gibbs

Reputation: 26363

Here's one way to get the list:

SELECT title
FROM movieitemdetails
WHERE barcode = '12345'
AND (
  SELECT COUNT(barcodes)
  FROM movieitemdetails_custom
  WHERE username = 'John'
) = 0
UNION SELECT title
FROM movieitemdetails_custom
WHERE username = 'John'
AND (
  SELECT COUNT(barcodes)
  FROM movieitemdetails_custom
  WHERE username = 'John'
) > 0

It's the end of a looong day so I hope I got the count zero/nonzero logic straight :)

BTW, I agree with @Max that the downvote was undeserved. I voted the question up.

Upvotes: 1

Ryan Schlueter
Ryan Schlueter

Reputation: 2221

 SELECT CASE WHEN countt = 0 THEN (SELECT barcodes FROM movieitemdetails WHERE username = 'John') 
 ELSE (SELECT barcodes FROM movieitemdetails_custom WHERE username = 'John')

Upvotes: 0

Related Questions