MySQL LEFT | Extract Characters from Left of String

MySQL Left is an inbuilt function in MySQL. It extracts a number of characters from a string starting from the left. In this article, we will discuss the MySQL Left Function. Also, we will discuss a few examples of using it. Also, you can read about MySQL RIGHT Function. Syntax LEFT(string, numberOfCharacters) Parameters The function expects… Read more MySQL LEFT | Extract Characters from Left of String

MySQL SPACE Function | String Specified Space Characters

MySQL SPACE is an inbuilt Function in MySQL. It returns a string containing a specified number of space characters. In this article, we will discuss the MySQL SPACE Function. Also, we will discuss a few examples of using it. Syntax SPACE (num_of_characters) Parameters The MySQL SPACE Function expects only one parameter. The number of space… Read more MySQL SPACE Function | String Specified Space Characters

MySQL Position Function | Position of Substring in String

MySQL Position is an inbuilt function in MySQL. It returns the position of the first occurrence of a substring in a string. However, if the substring does not exist then it returns 0. Moreover, the function performs a case-insensitive search (uppercase and lowercase characters are the same). In this article, we will discuss the MySQL… Read more MySQL Position Function | Position of Substring in String

MySQL Locate Function | Position of Substring in String

MySQL Locate is an inbuilt function in MySQL. It returns the position of the first occurrence of a substring in a string. However, if the substring does not exist then it returns 0. Moreover, the function performs a case-insensitive search (uppercase and lowercase characters are the same). In this article, we will discuss the MySQL… Read more MySQL Locate Function | Position of Substring in String

MySQL SUBSTRING_INDEX Function | Substring By Delimiter

MySQL SUBSTRING_INDEX is an inbuilt Function in MySQL. It returns a substring before the number of occurrences of a delimiter. In this article, we will discuss the MySQL SUBSTRING_INDEX Function. Also, we will discuss a few examples of using it. Moreover, you can also go through MySQL Substring Function which returns a substring by specifying… Read more MySQL SUBSTRING_INDEX Function | Substring By Delimiter