Return 0 if field is null in MySQL

by

Use IFNULL:

IFNULL(expr1, 0)

From the documentation:

If expr1 is not NULL, IFNULL() returns expr1; otherwise it returns expr2. IFNULL() returns a numeric or string value, depending on the context in which it is used.

More Related Contents:

  1. You can’t specify target table for update in FROM clause
  2. Generating a range of numbers in MySQL
  3. How to get next/previous record in MySQL?
  4. How do I make a row generator in MySQL?
  5. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  6. MySQL number of items within “in clause”
  7. Error 1046 No database Selected, how to resolve?
  8. What’s the difference between VARCHAR and CHAR?
  9. Alter a MySQL column to be AUTO_INCREMENT
  10. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  11. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  12. Mysql recursion?
  13. is there a group_concat function in ms-access?
  14. Is there an alternative to TOP in MySQL?
  15. How many rows in a database are TOO MANY?
  16. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  17. Is it possible to have an indexed view in MySQL?
  18. mysql – how many columns is too many?
  19. Best database field type for a URL
  20. Use A Union Or A Join – What Is Faster [closed]
  21. MySQL – how to front pad zip code with “0”?
  22. Find the number of columns in a table
  23. Mysql, reshape data from long / tall to wide
  24. MySQL: Compare differences between two tables
  25. Mysql strip time component from datetime
  26. How do I start auto increment from a specific point?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment