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 »

MySQL INSERT() Function – How to Insert Values Within A String In MySQL?

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 …

MySQL INSERT() Function – How to Insert Values Within A String In MySQL? Read More »