MySQL INSTR | Case Insensitive Position of String in String

MySQL INSTR Function is an inbuilt function in MySQL. It finds the first position of occurrence of a substring in another string. Moreover, it performs the search in a case-insensitive manner. In this article, we will discuss the MySQL INSTR Function. Also, we will discuss a few examples of using it. Syntax INSTR(string, substring) Parameters The… Read more MySQL INSTR | Case Insensitive Position of String in String

MySQL ASCII Function | Return ASCII Value of First Character

MySQL ASCII is an inbuilt function in MySQL. It returns the ASCII value of the first character of the input string to it. In this article, we will discuss the MySQL ASCII Function. Also, we will discuss a few examples of using it. Syntax ASCII (string) Parameters The MySQL ASCII Function expects only one parameter.… Read more MySQL ASCII Function | Return ASCII Value of First Character

MySQL INSERT Function | Insert String Within a String

MySQL INSERT function is an inbuilt function in MySQL. It inserts a string within another string removing the corresponding characters from the original string. In this article, we will discuss the MySQL INSERT Function. Also, we will discuss a few examples of using it. Syntax INSERT(string, position, length, replaceString) Parameters The MySQL INSERT Function expects four parameters.… Read more MySQL INSERT Function | Insert String Within a String

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