In the customers table, many customers do not have state data in the state column therefore when we select customers, the state column displays NULL values, which is not meaningful for the reporting purpose. Let’s take a look at the data in the customers table in the sample database. Try It Out Displaying N/A instead of NULL using MySQL IF function Try It Out SELECT IF( 1 = 1, ' true', 'false') - true Code language: SQL (Structured Query Language) ( sql )
You can use the IF function directly in the SELECT statement without the FROM and other clauses as follows: SELECT IF( 1 = 2, 'true', 'false') - false Code language: SQL (Structured Query Language) ( sql ) Let’s practice with several examples to see how the MySQL IF function works. The IF function that we cover in this tutorial is different from the IF statement. If the expr evaluates to TRUE i.e., expr is not NULL and expr is not 0, the IF function returns the if_true_expr, otherwise, it returns if_false_expr The IF function returns a numeric or a string, depending on how it is used. The syntax of the MySQL IF function is as follows: IF(expr,if_true_expr,if_false_expr) Code language: SQL (Structured Query Language) ( sql ) The IF function is sometimes referred to as IF ELSE or IF THEN ELSE function. MySQL IF function is one of the MySQL control flow functions that returns a value based on a condition.
#Mysql case select multiple columns how to#
Summary: in this tutorial, you will learn how to use MySQL IF function that returns a value based on a given condition.
0 kommentar(er)
