MySQL

In this tutorial, we will learn about the MySQL SQRT() function. In high school maths, you must have come across exercises involving finding the square root of a number. Furthermore, square root finds applications across geometry, calculus, statistics, physics and many other domains which makes it one of the essential mathematical operations. For this reason […]

In this tutorial, we will learn about the MySQL FIELD and ELT functions. The FIELD() function is used to return the position of value from a list of values. FIELD() is a case-insensitive function.  The ELT() function does the exact opposite of the FIELD() function. It is used to return the value at a given

In this tutorial, we will learn about the MySQL POW() and POWER() functions. Suppose you have to do certain calculations on the data in your table which involves finding the squares, cubes or other powers raised to the number. For such operations, MySQL provides us with the POW() and POWER() functions. The POW() and POWER()

In this tutorial, we will learn about the MySQL SUBSTRING_INDEX() function. SUBSTRING_INDEX() is a string function that is used to return the substring of a string before a specific number of occurrences of a given delimiter. For instance, you have the following string value – “192.168.1.10”. Now if you specify the delimiter as ‘.’ and

In this tutorial, we will learn about the MySQL SUBSTRING() and SUBSTR() functions. Both functions do the same thing but have different names. SUBSTRING() and SUBSTR() are used to extract a substring from a given string from a given position. You may also specify the number of characters you wish to extract into the substring.

In this tutorial, we will learn about the MySQL INSERT() function. Suppose you have a string ‘Java is my favorite programming language’. However, Java isn’t my only favorite programming language. I love MySQL too and so I want to change the string to ‘Java and MySQL are my favourite programming language’. This is where the

In this tutorial, we will study the MySQL LOCATE() function. The LOCATE() function is a string function which is used to find out the position of the first occurrence of a substring within a string. If the string does not contain the substring, then the position is returned as 0. The LOCATE() function performs a

In this tutorial, we will learn about the MySQL STRCMP() function. You may encounter a situation while working with tables where you might have to compare two string values and find out if they are equal or not. Suppose you have two strings, say “SQL” and “Python”. What if you want to compare them and

In this tutorial, we will learn about the MySQL LEFT() and RIGHT() functions. The LEFT() function is a string function that is used to extract a given number of characters from a string, starting from the left. For instance, you have a string with the value “JournalDev” and you want the first 7 characters from

In this tutorial, we will study the MySQL REPLACE() function. Sometimes, you may have to change the value of a substring within a string. This is where the MySQL REPLACE() function comes into the picture. The REPLACE() function is used to replace all the occurrences of a substring, with a new string. The REPLACE() function