MySQL CHARACTER_LENGTH Function | Length of String

MySQL CHARACTER_LENGTH is an inbuilt function in MySQL. It returns the length of the input string by counting the number of characters. Also, it ignores whether the characters are single-byte or multi-bytes. It simply counts the number of characters. In this article, we will discuss the MySQL CHARACTER_LENGTH Function. Note: This function is an alias… Read more MySQL CHARACTER_LENGTH Function | Length of String

MySQL RIGHT | Extract Characters from Right of String

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

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