MySQL Examples and Tutorials
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 …
MySQL SUBSTRING_INDEX() – Working with Substrings in MySQL Read More »
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 »
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 »
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 …
MySQL LOCATE() – Find Substrings in a String with MySQL Read More »
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 …
MySQL STRCMP() – How to Compare Two Strings in MySQL? Read More »
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 …
MySQL REPLACE() – Edit Strings and Replace Values in MySQL Read More »
In this tutorial, we will study the MySQL POSITION() function. Suppose you want to find where a substring value is located in a string. Operations like these can be common for string operations and manipulations on data in tables. This is where we use the MySQL POSITION() function. The MySQL POSITION() is used to find …
MySQL POSITION() – Find the position of a substring in a string in MySQL Read More »
In this tutorial, we will study the MySQL UPPER() and UCASE() functions. Just like LOWER() and LCASE(), UPPER() and UCASE() are synonyms of each other in MySQL. The UPPER() and UCASE() functions are string functions that are used to convert a string to uppercase alphabets. It is important to note that if there are any …
MySQL UPPER() and UCASE() – How to convert text to uppercase in MySQL? Read More »
In this tutorial, we will study the MySQL LOWER() and LCASE() functions. LOWER() and LCASE() are synonyms of each other in MySQL. They have a different name but do the same thing. The LOWER() and LCASE() functions are string functions that are used to convert a string to lower-case alphabets. For instance, if you have …
MySQL LOWER() and LCASE() – How to convert text to lowercase in MySQL? Read More »