How do I display certain text for blank results in a column. MYSQL
<p>I'm needing to display the words "None provided" for any customers that did not give a second address. What would I use to only provide the address2 column with those words where the return is blank?</p>

<pre><code>/* Create a customer list that shows the customer name, address, second address (if the customer does not list a second address, print out "none provided") 
and postal code. */

SELECT CONCAT(first_name," ",last_name) AS Name,
CONCAT(address.address,",",address.address2,",",postal_code) AS Customer_info
FROM customer
INNER JOIN address
ON customer.address_id = address.address_id;
</code></pre>