Search results
The IF statement can have THEN, ELSE, and ELSEIF clauses, and it is terminated with END IF. If a given search_condition evaluates to true, the corresponding THEN or ELSEIF clause statement_list executes. If no search_condition matches, the ELSE clause statement_list executes.
Syntax. IF (condition, value_if_true, value_if_false) Parameter Values. Technical Details. Works in: From MySQL 4.0. More Examples. Example. Return 5 if the condition is TRUE, or 10 if the condition is FALSE: SELECT IF (500<1000, 5, 10); Try it Yourself » Example. Test whether two strings are the same and return "YES" if they are, or "NO" if not:
This tutorial shows you how to use MySQL IF statement to execute a block of SQL code based on a specified condition.
The world's most popular open source database Contact MySQL | Login | Register. MySQL.com; Downloads; Documentation; Developer Zone
13 kwi 2020 · A cheat sheet for MySQL with essential commands. Work with tables, columns, data types, indexes, functions, and more. Free to download as .pdf.
15 gru 2012 · You can use the if - else control structure or the IF function in MySQL. Reference: http://easysolutionweb.com/sql-pl-sql/how-to-use-if-and-else-in-mysql/
This MySQL tutorial explains how to use the IF-THEN-ELSE statement in MySQL with syntax and examples. In MySQL, the IF-THEN-ELSE statement is used to execute code when a condition is TRUE, or execute different code if the condition evaluates to FALSE.
