Returning a value even if no result

by

MySQL has a function to return a value if the result is null. You can use it on a whole query:

SELECT IFNULL( (SELECT field1 FROM table WHERE id = 123 LIMIT 1) ,'not found');

More Related Contents:

  1. NOT LIKE not working with SHOW [duplicate]
  2. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. How to define a custom ORDER BY order in mySQL
  6. How can I temporarily disable a foreign key constraint in MySQL?
  7. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  8. How to get the number of days of difference between two dates on MySQL?
  9. MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
  10. conditional join in mysql
  11. MYSQL Select MAX Date inside a join statement
  12. How to grant all privileges to root user in MySQL 8.0
  13. MySQL Group by SUM
  14. TRIGGERs that cause INSERTs to fail? Possible?
  15. Mysql query to dynamically convert rows to columns on the basis of two columns
  16. Search for all occurrences of a string in a mysql database [duplicate]
  17. Count days between two dates, excluding weekends (MySQL only)
  18. MySQL: How do I join same table multiple times?
  19. Difference in minutes from two time fields in MySQL
  20. error code 1292 incorrect date value mysql
  21. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  22. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  23. How to swap values of two rows in MySQL without violating unique constraint?
  24. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  25. Would it help to add index to BIGINT column in MySQL?
  26. ALTER TABLE ADD COLUMN takes a long time
  27. Creating MYSQL Procedure in Laravel 4 Migrations
  28. MySQL: Computed Column
  29. Mysql server does not support 4-byte encoded utf8 characters
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment