Yahoo India Web Search

Search results

1. www.w3schools.com › SQL › func_mysql_caseMySQL CASE Function - W3Schools

   www.w3schools.com › SQL › func_mysql_case

   • Cached

   Learn how to use the CASE statement in MySQL to go through conditions and return a value when the first condition is met. See syntax, examples and technical details of this function.

2. Videos

   • 4:23

     youtube.com

     How to use CASE Statement in MySQL

     29 Oct 2020

     7.3K views

   • 34:35

     youtube.com

     Case statement in MySQL | MySQL Tutorial For beginners | Great Learning

     11 Nov 2020

     2.8K views

   • 8:37

     youtube.com

     How to Use IF and CASE WHEN in MySQL Workbench SQL Tutorial

     4 Jan 2021

     28.8K views

   View all

3. www.mysqltutorial.org › mysql-case-functionMySQL CASE Expressions

   www.mysqltutorial.org › mysql-case-function

   • Cached

   MySQL CASE expression is a control flow structure that allows you to add if-else logic to a query. Generally speaking, you can use the CASE expression anywhere that allows a valid expression e.g., SELECT, WHERE and ORDER BY clauses. The CASE expression has two forms: simple CASE and searched CASE. Note that MySQL has a CASE statement that you ...

4. www.geeksforgeeks.org › case-function-in-mysqlMySQL CASE() Function - GeeksforGeeks

   www.geeksforgeeks.org › case-function-in-mysql

   • Cached

   Apr 23, 2024 · Learn how to use the CASE function in MySQL to apply conditional logic within queries. See syntax, parameters, examples and important points about this function.

5. People also ask

   What is a case statement in MySQL?

   • Besides the IF statement, MySQL provides an alternative conditional statement called the CASE statement used in stored procedures. The CASE statements make the code more readable and efficient. The CASE statement has two forms: Searched CASE statement.

   Using MySQL CASE Statements in Stored Procedures

   www.mysqltutorial.org/mysql-stored-procedure/mysql-case-statement/

   See all results for this question

   What is a case function in MySQL?

   • The CASE function syntax in MySQL is given below Parameters: This method accepts two parameters as given below: condition1, condition2, …conditionN: Specified conditions which are determined in the order they are stated. result1, result2, …resultN: Specified output which is to be returned if the stated condition is satisfied.

   MySQL CASE() Function - GeeksforGeeks

   www.geeksforgeeks.org/case-function-in-mysql/

   See all results for this question

   What is a case expression in MySQL?

   • MySQL CASE expression is a control flow structure that allows you to add if-else logic to a query. Generally speaking, you can use the CASE expression anywhere that allows a valid expression e.g., SELECT, WHERE and ORDER BY clauses. The CASE expression has two forms: simple CASE and searched CASE.

   MySQL CASE Expressions

   www.mysqltutorial.org/mysql-control-flow-functions/mysql-case-function/

   See all results for this question

   What is a case statement in SQL?

   • The CASE statements make the code more readable and efficient. The CASE statement has two forms: Searched CASE statement. Note that if you want to add the if-else logic to an SQL statement, you use the CASE expression which differs from the CASE statement covered in this tutorial.

   Using MySQL CASE Statements in Stored Procedures

   www.mysqltutorial.org/mysql-stored-procedure/mysql-case-statement/

   See all results for this question

6. dev.mysql.com › doc › refmanMySQL :: MySQL 8.4 Reference Manual :: 15.6.5.1 CASE Statement

   dev.mysql.com › doc › refman

   • Cached

   Learn how to use the CASE statement for stored programs in MySQL 8.4. The CASE statement implements a complex conditional construct with multiple WHEN and THEN clauses and an optional ELSE clause.

7. www.mysqltutorial.org › mysql-case-statementUsing MySQL CASE Statements in Stored Procedures

   www.mysqltutorial.org › mysql-case-statement

   • Cached

   Besides the IF statement, MySQL provides an alternative conditional statement called the CASE statement used in stored procedures. The CASE statements make the code more readable and efficient. The CASE statement has two forms: Simple CASE statement. Searched CASE statement. Note that if you want to add the if-else logic to an SQL statement ...

8. www.techonthenet.com › mysql › functionsMySQL: CASE Function - TechOnTheNet

   www.techonthenet.com › mysql › functions

   This MySQL tutorial explains how to use the MySQL CASE function with syntax and examples. The MySQL CASE function has the functionality of an IF-THEN-ELSE statement by allowing you to evaluate conditions and return a value when the first condition is met.

9. www.mysqltutor.com › mysql-caseMySQL CASE - MySQL Tutorial

   www.mysqltutor.com › mysql-case

   • Cached

   Learn how to use the CASE statement in MySQL to perform conditional logic within SQL queries. See syntax, examples, and applications of the CASE statement in various clauses and functions.