{"version":"1.0","provider_name":"Career Karma","provider_url":"https:\/\/careerkarma.com\/blog","title":"Using MySQL\u2019s IF(), NULLIF(), and IFNULL() Functions","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"HCPSAU3CKq\"><a href=\"https:\/\/careerkarma.com\/blog\/sql-if-functions\/\">Using MySQL\u2019s IF(), NULLIF(), and IFNULL() Functions<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/careerkarma.com\/blog\/sql-if-functions\/embed\/#?secret=HCPSAU3CKq\" width=\"600\" height=\"338\" title=\"&#8220;Using MySQL\u2019s IF(), NULLIF(), and IFNULL() Functions&#8221; &#8212; Career Karma\" data-secret=\"HCPSAU3CKq\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/careerkarma.com\/blog\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","thumbnail_url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/pexels-pixabay-356079.jpg","thumbnail_width":1020,"thumbnail_height":617,"description":"MySQL has IF functions that allow us to control the data flow in our SQL statement blocks. Learn how to use IF(), NULLIF(), and IFNULL() in this article by Career Karma."}