• Home
  • Whiteboard
  • Online Compilers
  • Practice
  • Articles
  • AI Assistant
  • Jobs
  • Tools
  • Corporate Training
  • Courses
  • Certifications
Login
    • Java
    • JSP
    • iOS
    • HTML
    • Android
    • Python
    • C Programming
    • C++ Programming
    • C#
    • PHP
    • CSS
    • Javascript
    • jQuery
    • SAP
    • SAP HANA
    • Data Structure
    • RDBMS
    • MySQL
    • Mathematics
    • 8085 Microprocessor
    • Operating System
    • Digital Electronics
    • Analysis of Algorithms
    • Mobile Development
    • Front End
    • Web Development
    • Selenium
    • MongoDB
    • Computer Network
    • General Topics
  • Library
  • Courses
  • Certifications
  • Login
  • SQL
  • HTML
  • CSS
  • Javascript
  • Python
  • Java
  • C
  • C++
  • PHP
  • Scala
  • C#
  • Tailwind CSS
  • Node.js
  • MySQL
  • MongoDB
  • PL/SQL
  • Swift
  • Bootstrap
  • R
  • Machine Learning
  • Blockchain
  • Angular
  • React Native
  • Computer Fundamentals
  • Compiler Design
  • Operating System
  • Data Structure and Algorithms
  • Computer Network
  • DBMS
  • Excel
Technical Questions and Answers
  • Data Structure Data Structure
  • Networking Networking
  • RDBMS RDBMS
  • Operating System Operating System
  • Java Java
  • MS Excel MS Excel
  • iOS iOS
  • HTML HTML
  • CSS CSS
  • Android Android
  • Python Python
  • C Programming C Programming
  • C++ C++
  • C# C#
  • MongoDB MongoDB
  • MySQL MySQL
  • Javascript Javascript
  • PHP PHP
  • Selected Reading
  • UPSC IAS Exams Notes
  • Developer's Best Practices
  • Questions and Answers
  • Effective Resume Writing
  • HR Interview Questions
  • Computer Glossary
  • Who is Who

MySQL NULLIF Function Similar to CASE Statement

MySQLMySQLi Database


As we know that MySQL NULLIF() control flow function will return NULL if both the arguments are the same, otherwise it returns the first argument. Hence it is similar to the following CASE statement −

CASE
WHEN expression1=expression2 THEN NULL
ELSE
Expression2
END.
Lakshmi Srinivas
Lakshmi Srinivas

Updated on: 2020-06-22T06:56:34+05:30

99 Views

  • Related Articles
  • What is the use of MySQL NULLIF() control flow function?
  • How does MYSQL control flow function CASE works?
  • What is the use of MySQL IFNULL() control flow function?
  • What is difference between cash flow statement and fund flow statement?
  • MySQL case statement inside a select statement?
  • Difference Between Cash Flow Statement and Funds Flow Statement
  • What is the difference between Flow Control and Error Control?
  • What is Information Flow Control under Cybersecurity?
  • Which is faster, a MySQL CASE statement or a PHP if statement?
  • Select Statement to retrieve the same first names with similar last name (but different case) using MySQL?
  • Static Control Flow in Java
  • Control flow alterations in Ruby
  • Instance Control Flow in Java
  • How to use MySQL CASE statement while using UPDATE Query?
  • Implement MySQL CASE statement with WHEN clause
Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements
TOP TUTORIALS
  • Python Tutorial
  • Java Tutorial
  • C++ Tutorial
  • C Programming Tutorial
  • C# Tutorial
  • PHP Tutorial
  • R Tutorial
  • HTML Tutorial
  • CSS Tutorial
  • JavaScript Tutorial
  • SQL Tutorial
TRENDING TECHNOLOGIES
  • Cloud Computing Tutorial
  • Amazon Web Services Tutorial
  • Microsoft Azure Tutorial
  • Git Tutorial
  • Ethical Hacking Tutorial
  • Docker Tutorial
  • Kubernetes Tutorial
  • DSA Tutorial
  • Spring Boot Tutorial
  • SDLC Tutorial
  • Unix Tutorial
CERTIFICATIONS
  • Business Analytics Certification
  • Java & Spring Boot Advanced Certification
  • Data Science Advanced Certification
  • Cloud Computing And DevOps
  • Advanced Certification In Business Analytics
  • Artificial Intelligence And Machine Learning
  • DevOps Certification
  • Game Development Certification
  • Front-End Developer Certification
  • AWS Certification Training
  • Python Programming Certification
COMPILERS & EDITORS
  • Online Java Compiler
  • Online Python Compiler
  • Online Golang Compiler
  • Online C Compiler
  • Online C++ Compiler
  • Online C# Compiler
  • Online PHP Compiler
  • Online MATLAB Compiler
  • Online Bash Compiler
  • Online SQL Compiler
  • Online Html Editor
  • ABOUT US |
  • OUR TEAM |
  • CAREERS |
  • JOBS |
  • CONTACT US |
  • TERMS OF USE |
  • PRIVACY POLICY |
  • REFUND POLICY |
  • COOKIES POLICY |
  • FAQ'S
tutorials point logo

Tutorials Point is a leading Ed Tech company striving to provide the best learning material on technical and non-technical subjects.

© Copyright 2025. All Rights Reserved.