MySQL IF NOT NULL, then display 1, else display 0

Instead of COALESCE(a.addressid,0) AS addressexists, use CASE:

CASE WHEN a.addressid IS NOT NULL 
       THEN 1
       ELSE 0
END AS addressexists

or the simpler:

(a.addressid IS NOT NULL) AS addressexists

This works because TRUE is displayed as 1 in MySQL and FALSE as 0.

Related Posts:

  1. If variable equals value php [duplicate]
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. Cannot add or update a child row: a foreign key constraint fails
  4. String concatenation in MySQL
  5. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  6. MySQL server startup error ‘The server quit without updating PID file’
  7. Rename a column in MySQL
  8. How do I restore a dump file from mysqldump?
  9. SQL – Update multiple records in one query
  10. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  11. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  12. Create a new database with MySQL Workbench
  13. Column ‘user_id’ in field list is ambiguous
  14. Database sharding vs partitioning
  15. 1052: Column ‘id’ in field list is ambiguous
  16. Escape string Python for MySQL
  17. 1052: Column ‘id’ in field list is ambiguous
  18. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  19. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  20. difference between primary key and unique key
  21. how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
  22. SQL ZOO List each continent and the name of the country that comes first alphabetically
  23. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  24. MySQL date formats – difficulty Inserting a date
  25. How to grant remote access permissions to mysql server for user?
  26. How to check if mysql database exists
  27. #1062 – Duplicate entry for key ‘PRIMARY’
  28. How can I convert a string to a float in mysql?
  29. Is there a Profiler equivalent for MySql?
  30. How to use greater than operator with date?
  31. Data is not constantly loading from custom wordpress table
  32. How to replace the domain name in a WordPress database?
  33. Mysqldump add drop table?
  34. Optimize WordPress Query that take 5 seconds to execute
  35. MySQL Replication Latency Issues in wp-admin pages
  36. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  37. Increment value (value = value+1) of $wpdb->update
  38. #1115 – Unknown character set: ‘utf8mb4’
  39. How can I debug my database connection for unit testing?
  40. Extending the database
  41. SQL query not working in alphabetical post title/content search
  42. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  43. Importing MariaDB into Mysql in WordPress
  44. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  45. Converting mysql to $wpdb
  46. Best settings for MySQL to speed up site? [closed]
  47. Update a WordPress post or page takes 60+ seconds
  48. HTML Entities in Post Title
  49. add_post_meta does not respect the content
  50. Modify MySQL Query Based on Dropdown Menu
  51. Select multiple wp_postmeta keys with single select
  52. Can’t find my wordpress DB in phpmyadmin
  53. Backing up and restoring multiple sites efficiently
  54. Alter wp_post table vs. post_meta performance/speed
  55. Calculate average crossing post categories
  56. Many slow queries post_type = ‘attachment’;
  57. SQL command to convert all tags in lowercase?
  58. Are these WordPress tables safe to add indexes to?
  59. Is it possible to create a WordPress table using array and loop?
  60. SQL syntax error when getting data for a url
  61. Import CSV to MySQL, with custom registration field information
  62. Locally restoring a ManageWP full site backup
  63. WordPress doesn’t save changes some times
  64. Match tag names with form titles
  65. Error missing MySQL extension
  66. Update Custom Post Type Taxonomies with SQL
  67. Getting Error Trying to Create Table
  68. Custom SELECT Query not returning the_title and the_permalink
  69. Why doesn’t custom mysql query return results? Is syntax correct?
  70. Will reducing mysql permissions hinder WP function? [duplicate]
  71. Php Mysql Terms
  72. Export SQL query based on custom field?
  73. Lock wait timeout exceeded; try restarting transaction
  74. How to install WordPress from hosting service with mysql database from Compute Engine GCP?
  75. 504 Gateway Time-out after custom plugin inserts data into mysql database
  76. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  77. What is this? MySQL array?
  78. Regular XML-RPC timeouts
  79. What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
  80. Why should be SQL keywords, like CREATE TABLE and UPDATE, must be uppercase in WordPress?
  81. Add row to SQL array
  82. SELECT statement wrong?
  83. $wpdb->get_var not returning count
  84. mysql query on wp_user and user_meta problem
  85. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  86. Custom user query – orderby meta_key (that may not exist)
  87. Use custom query if main search query returns zero results in wordpress
  88. get_results() query not working only when entering strings
  89. Geographical proximity query using post_meta
  90. Can I use mysql queries to replace query_posts()?
  91. Add value to array in database
  92. How to Import Multiple Values in custom field
  93. Making CURDATE() recognize current_time()
  94. How should I troubleshoot a database serialization issue with a WordPress migration
  95. How WP decide to show or not to show in admin panel the pop-up window with hint? Need a fix
  96. SQL – Pull products of particular category from a remote WordPress woocommerce db
  97. Efficiently loop over huge number of posts
  98. Using queries in and i see 7000+queries?
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment