Category: MySQL

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 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 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 FIND_IN_SET is an inbuilt function in MySQL. It returns the position of a string in a list of string separated by commas. Also, the function performs the search in a case-insensitive manner. In this article, we will discuss the MySQL FIND_IN_SET Function. Also, we will discuss a few examples of using it. Note: The… Read more MySQL FIND_IN_SET | String Position in List of Strings

The FORMAT Function is an inbuilt function in MySQL. It converts a number in a format like “#,###,###.###” after rounding it to a specified number of decimal places. Also, it returns the number as a string. In this article, we will discuss the MySQL FORMAT Function. Also, we will discuss a few examples of using… Read more MySQL FORMAT Function | Format a Number after Rounding

MySQL FIELD is an inbuilt function in MySQL. It returns the index position of a value in a list of values. It compares the position of a value in a list of remaining values in a case-insensitive search. In this article, we will discuss the MySQL FIELD Function. Also, we will discuss a few examples… Read more MySQL FIELD Function | Get Position of Value in a List

MySQL LENGTH is an inbuilt function in MySQL. It returns the length of the input string according to a total number of bytes of the characters. Therefore, it does not ignore whether the characters are single-byte or multi-bytes. It counts a single byte character as 1 and a 2-byte character as 2. In this article,… Read more MySQL 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 CHAR_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 CHAR_LENGTH Function. Also, we will discuss a few… Read more MySQL CHAR_LENGTH Function | Length of String