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
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
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 