We may occasionally need to search within a string for a certain text. Multiple built-in functions provided by MySQL made the task simple. To extract
Category: MySQL
IF Condition in MySQL
A condition is verified using the MySQL IF() function. If the condition is TRUE, the IF() function returns a value, and if the condition is
Multiple ways to display the list of databases in MySQL
The list of databases is frequently viewed by developers and DBAs. There are alternative methods for seeing the databases depending on whether you want to
Multiple ways to display the list of tables in MySQL
The tables of a database are frequently listed by developers and DBAs. There are various methods for seeing the tables depending on whether you want
ISNULL in MySQL and SQL Server
ISNULL function behaves differently in MySQL and Microsoft SQL Server. In MySQL, ISNULL tests whether the given expression is NULL. It returns 1 if the
Compare Strings in MySQL
In SQL, a built-in function is a programming object that takes zero or more inputs and returns a value. A feature that is built into
Big Data & SQL 