MySQL FIELD() and ELT()

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 …

MySQL FIELD() and ELT() Read More »

MySQL SUBSTRING() and SUBSTR() Functions – How to extract substrings in MySQL?

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. …

MySQL SUBSTRING() and SUBSTR() Functions – How to extract substrings in MySQL? Read More »