{"id":8427,"date":"2021-01-19T05:34:00","date_gmt":"2021-01-19T05:34:00","guid":{"rendered":"https:\/\/ubiq.co\/tech-blog\/?p=8427"},"modified":"2025-09-01T05:05:06","modified_gmt":"2025-09-01T05:05:06","slug":"how-to-use-coalesce-in-mysql","status":"publish","type":"post","link":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/","title":{"rendered":"How to Use Coalesce in MySQL"},"content":{"rendered":"\n<p>Coalesce is a useful MySQL function that automatically returns first non-null value from a list of values. These values can be provided using literals, column names, or other MySQL functions. In this article, we will look at how to use Coalesce in MySQL.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#What_is_COALESCE_in_MySQL\" >What is COALESCE in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#Why_COALESCE_is_used_in_MySQL\" >Why COALESCE is used in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#COALESCE_vs_IFNULL_MySQL\" >COALESCE vs IFNULL MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#How_to_Use_Coalesce_in_MySQL\" >How to Use Coalesce in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#1_Using_Literal_Values\" >1. Using Literal Values<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#2_Using_Columns\" >2. Using Columns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#3_Using_SQL_Functions\" >3. Using SQL Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#4_To_Substitute_Null_Values\" >4. To Substitute Null Values<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#Conclusion\" >Conclusion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#COALESCE_in_Ubiq\" >COALESCE in Ubiq<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_COALESCE_in_MySQL\"><\/span>What is COALESCE in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>COALESCE function returns the first non NULL value from a list of values. If all values in the list are NULL, then it returns NULL. Here is the syntax of Coalesce function in MySQL.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">select coalesce(value1, value2, ..., valuen) \nfrom table_name;<\/pre>\n\n\n\n<p>In the above statement, you need to specify table name, and provide a list of comma-separated values. These values can be of any data type. They can all be of same or different data type. Please note, an empty value will not be treated as null. You need to explicitly state it, or it has to be column value.<\/p>\n\n\n\n<p>When you call coalesce() function, it will evaluate the list of values from left to right and return the first non-null value. It is similar to CASE statement.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_COALESCE_is_used_in_MySQL\"><\/span>Why COALESCE is used in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>COALESCE is used in MySQL to substitute null values with some other string of your choice. This is very useful for reporting and analytics where you don&#8217;t want to change the actual data but need to report it in a different way.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"COALESCE_vs_IFNULL_MySQL\"><\/span>COALESCE vs IFNULL MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Although IFNULL also can be used to substitute NULL values, it can accept only 2 arguments, returns the 1st argument if it is null, else returns second argument. COALESCE works with any number of arguments, not just two.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Use_Coalesce_in_MySQL\"><\/span>How to Use Coalesce in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>We will look at some of the most common uses cases to use COALSCE in MySQL.<\/p>\n\n\n\n<p>Here are some simple examples to show the functionality of COALESCE.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Using_Literal_Values\"><\/span>1. Using Literal Values<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In the following two examples, we use coalesce() function to get the first non-null value from a list of literal values. In the first case, the first value itself is null so the second value is returned. In the second example, all the values are null so the result is null.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; select coalesce(NULL, 2, 3);\n+----------------------+\n| coalesce(NULL, 2, 3) |\n+----------------------+\n|                    2 |\n+----------------------+\n\nmysql&gt; select coalesce(NULL, NULL);\n+----------------------+\n| coalesce(NULL, NULL) |\n+----------------------+\n|                 NULL |\n+----------------------+<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Using_Columns\"><\/span>2. Using Columns<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this example, we will call coalesce() function on multiple column names of a table.<\/p>\n\n\n\n<p>Let us say you have the following table <em>sales(id, product, order_date, amount)<\/em> which contains null values.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; create table sales(id int, \n        product varchar(5),\n        order_date date, \n        amount int);\n\nmysql&gt; insert into sales(id, product, order_date, amount)\n       values(null, 'A','2020-01-01',150),\n       (2, null,'2020-01-01',150),\n       (null, 'C',null,150),\n       (4, 'D','2020-01-01',null);\n\nmysql&gt; select * from sales;\n+------+---------+------------+--------+\n| id   | product | order_date | amount |\n+------+---------+------------+--------+\n| NULL | A       | 2020-01-01 |    150 |\n|    2 | NULL    | 2020-01-01 |    150 |\n| NULL | C       | NULL       |    150 |\n|    4 | D       | 2020-01-01 |   NULL |\n+------+---------+------------+--------+<\/pre>\n\n\n\n<p>Now we will use COALESCE to get first non-null value from each row.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; select id,coalesce(id, product, order_date, amount) from sales;<br>+----+-------------------------------------------+<br>| id | coalesce(id, product, order_date, amount) |<br>+----+-------------------------------------------+<br>| 1  | A                                         |<br>| 2  | 2                                         |<br>| 3  | C                                         |<br>| 4  | 4                                         |<br>+----+-------------------------------------------+<\/pre>\n\n\n\n<p>As you can see, COALESCE returns non-null values from each row. For each row, coalesce() will evaluate the list of column values id, product, order_date, amount and return the first non-null value. We also display the id value for each column. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Using_SQL_Functions\"><\/span>3. Using SQL Functions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this example, we will call coalesce() function on result of other SQL functions and operators.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; select coalesce(id*10, product, order_date - interval 10 days, floor(amount\/10)) from sales;<\/pre>\n\n\n\n<p>In the above example, the first argument of coalesce function is id column multiplied by 10, the next column product as it is, the 3rd column is order_date minus 10 days, and the last column is a result of floor() function called on amount\/10. All these are valid and work in coalesce function.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_To_Substitute_Null_Values\"><\/span>4. To Substitute Null Values<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You can also use COALESCE function to substitute null values with custom strings. In the following example, we will replace each null value with &#8216;NA&#8217; string using COALESCE.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; select coalesce(id, 'NA') id, \n       coalesce(product,'NA') product, \n       coalesce(order_date,'NA') order_date, \n       coalesce(amount,'NA') amount \n       from sales;\n +------+---------+------------+--------+\n | id   | product | order_date | amount |\n +------+---------+------------+--------+\n | NA   | A       | 2020-01-01 | 150    |\n | 2    | NA      | 2020-01-01 | 150    |\n | NA   | C       | NA         | 150    |\n | 4    | D       | 2020-01-01 | NA     |\n +------+---------+------------+--------+<\/pre>\n\n\n\n<p>This is a useful way to clean up your data and replace null values in it with something more intuitive or user friendly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this article, we have learnt what is coalesce() function in MySQL, why it is used and how to use it. We have learnt several common use cases such as with literals and columns. We have also learnt how to call coalesce on result of SQL operators and functions. Lastly, we have learnt how to use it to substitute null values with other suitable strings, for reporting purposes. Coalesce is commonly used in numerous organizations for data analysis and reporting. It allows you to easily detect null values in your data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"COALESCE_in_Ubiq\"><\/span>COALESCE in Ubiq<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><a href=\"https:\/\/ubiq.co\/\">Ubiq<\/a>&nbsp;Reporting tool supports all the above SQL queries and makes it easy to visualize SQL results in different ways. Here is the COALESCE SQL query mentioned above, in Ubiq.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"461\" src=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/image.webp?resize=730%2C461&#038;ssl=1\" alt=\"\" class=\"wp-image-8430\"\/><\/figure>\n<\/div>\n\n\n<p>Need a reporting tool for MySQL?&nbsp;<a href=\"http:\/\/ubiq.co\/\">Ubiq<\/a>&nbsp;makes it easy to visualize data in minutes, and monitor in real-time dashboards.&nbsp;<a href=\"http:\/\/ubiq.co\/accounts\/register\">Try it<\/a>&nbsp;Today!<\/p>\n\n\n\n<p>Also read:<br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-query-json-column-in-mysql\/\">How to Query JSON Column in MySQL<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-avoid-inserting-duplicate-records-in-mysql\/\">How to Avoid Inserting Duplicate Records in MySQL<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-convert-datetime-to-utc-in-mysql\/\">How to Convert Datetime to UTC in MySQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.<\/p>\n","protected":false},"author":1,"featured_media":8429,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[324],"tags":[449],"class_list":["post-8427","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-coalesce-function"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Use Coalesce in MySQL - Ubiq BI<\/title>\n<meta name=\"description\" content=\"Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use Coalesce in MySQL - Ubiq BI\" \/>\n<meta property=\"og:description\" content=\"Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ubiq BI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ubiqbi\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-19T05:34:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-01T05:05:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/coalesce-in-mysql.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"410\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Sreeram Sreenivasan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:site\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreeram Sreenivasan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/\"},\"author\":{\"name\":\"Sreeram Sreenivasan\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"headline\":\"How to Use Coalesce in MySQL\",\"datePublished\":\"2021-01-19T05:34:00+00:00\",\"dateModified\":\"2025-09-01T05:05:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/\"},\"wordCount\":745,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/coalesce-in-mysql.webp?fit=720%2C410&ssl=1\",\"keywords\":[\"coalesce function\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/\",\"name\":\"How to Use Coalesce in MySQL - Ubiq BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/coalesce-in-mysql.webp?fit=720%2C410&ssl=1\",\"datePublished\":\"2021-01-19T05:34:00+00:00\",\"dateModified\":\"2025-09-01T05:05:06+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"description\":\"Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/coalesce-in-mysql.webp?fit=720%2C410&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/coalesce-in-mysql.webp?fit=720%2C410&ssl=1\",\"width\":720,\"height\":410,\"caption\":\"coalesce in mysql\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-use-coalesce-in-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Use Coalesce in MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\",\"name\":\"Ubiq BI\",\"description\":\"Build dashboards &amp; reports in minutes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\",\"name\":\"Sreeram Sreenivasan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"caption\":\"Sreeram Sreenivasan\"},\"description\":\"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/sreeram-sreenivasan\\\/\"],\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/author\\\/wordpress\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Use Coalesce in MySQL - Ubiq BI","description":"Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"How to Use Coalesce in MySQL - Ubiq BI","og_description":"Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.","og_url":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/","og_site_name":"Ubiq BI","article_publisher":"https:\/\/www.facebook.com\/ubiqbi","article_published_time":"2021-01-19T05:34:00+00:00","article_modified_time":"2025-09-01T05:05:06+00:00","og_image":[{"width":720,"height":410,"url":"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/coalesce-in-mysql.webp","type":"image\/webp"}],"author":"Sreeram Sreenivasan","twitter_card":"summary_large_image","twitter_creator":"@UbiqBI","twitter_site":"@UbiqBI","twitter_misc":{"Written by":"Sreeram Sreenivasan","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#article","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/"},"author":{"name":"Sreeram Sreenivasan","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"headline":"How to Use Coalesce in MySQL","datePublished":"2021-01-19T05:34:00+00:00","dateModified":"2025-09-01T05:05:06+00:00","mainEntityOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/"},"wordCount":745,"commentCount":0,"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/coalesce-in-mysql.webp?fit=720%2C410&ssl=1","keywords":["coalesce function"],"articleSection":["MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/","url":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/","name":"How to Use Coalesce in MySQL - Ubiq BI","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#primaryimage"},"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/coalesce-in-mysql.webp?fit=720%2C410&ssl=1","datePublished":"2021-01-19T05:34:00+00:00","dateModified":"2025-09-01T05:05:06+00:00","author":{"@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"description":"Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.","breadcrumb":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#primaryimage","url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/coalesce-in-mysql.webp?fit=720%2C410&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/coalesce-in-mysql.webp?fit=720%2C410&ssl=1","width":720,"height":410,"caption":"coalesce in mysql"},{"@type":"BreadcrumbList","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-use-coalesce-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ubiq.co\/tech-blog\/"},{"@type":"ListItem","position":2,"name":"How to Use Coalesce in MySQL"}]},{"@type":"WebSite","@id":"https:\/\/ubiq.co\/tech-blog\/#website","url":"https:\/\/ubiq.co\/tech-blog\/","name":"Ubiq BI","description":"Build dashboards &amp; reports in minutes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ubiq.co\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc","name":"Sreeram Sreenivasan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","caption":"Sreeram Sreenivasan"},"description":"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.","sameAs":["https:\/\/www.linkedin.com\/in\/sreeram-sreenivasan\/"],"url":"https:\/\/ubiq.co\/tech-blog\/author\/wordpress\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/coalesce-in-mysql.webp?fit=720%2C410&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pbGGTT-2bV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8427","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/comments?post=8427"}],"version-history":[{"count":4,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8427\/revisions"}],"predecessor-version":[{"id":9383,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8427\/revisions\/9383"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media\/8429"}],"wp:attachment":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media?parent=8427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/categories?post=8427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/tags?post=8427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}