Return a default value if single row is not found

by

One way to do it 

SELECT IFNULL(MIN(`file`), 'default.webm') `file` 
  FROM `show`, `schedule` 
 WHERE `channel` = 1 AND `start_time` <= UNIX_TIMESTAMP() 
   AND `start_time` > UNIX_TIMESTAMP()-1800 AND `show`.`id` = `schedule`.`file` 
 ORDER BY `start_time` DESC LIMIT 1

Since you return only one row, you can use an aggregate function, in that case MIN(), that ensures that you’ll get NULL if no records selected. Then IFNULL() or COALESCE() will do its job.

More Related Contents:

  1. What is better subquery vs literal on IN clause in mysql
  2. SQL query return data from multiple tables
  3. Select all columns except one in MySQL?
  4. quick selection of a random row from a large table in mysql
  5. MySQL: is a SELECT statement case sensitive?
  6. MySQL SELECT only not null values
  7. How to change MySQL data directory?
  8. Combine Multiple child rows into one row MYSQL
  9. MySQL SELECT increment counter
  10. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  11. How to get an age from a D.O.B field in MySQL?
  12. How does MySQL’s ORDER BY RAND() work?
  13. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  14. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  15. How do I get the first day of the week of a date in mysql?
  16. MySQL INSERT INTO … VALUES and SELECT
  17. Mysql select distinct
  18. MySQL error 1241: Operand should contain 1 column(s)
  19. How to select one row randomly taking into account a weight?
  20. Compare only day and month with date field in mysql
  21. mysql select sum group by date
  22. MySQL – SQL_BIG_SELECTS
  23. MySQL INNER JOIN select only one row from second table
  24. MySQL Select Query – Get only first 10 characters of a value
  25. What is the default MySQL JOIN behaviour, INNER or OUTER?
  26. Insert data into table with result from another select query
  27. How to SELECT by MAX(date)?
  28. How to use Table output from stored MYSQL Procedure
  29. MySQL: set field default value to other column
  30. MySQL cartesian product between two SELECT statements

Leave a Comment