MySQL String Functions

MySQL has many built-in functions. They are very useful in manipulating string values from columns. Explore different MySQL String Functions on Concatly!

Articles

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 ...
Read More

MySQL CHAR_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, ...
Read More

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: ...
Read More

MySQL Concat Function | Join Strings in MySQL

In this article, I will talk about the concatenation of two or more strings in MySQL using MySQL CONCAT Function. Concatenation, in the context of programming, is the operation of joining two strings together. The term"concatenation" literally means to merge two things together.https://techopedia.com MySQL provides two functions that concatenate string ...
Read More

MySQL FIELD Function | Get Position of Value in a List

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 ...
Read More

MySQL FIND_IN_SET | String Position in List of Strings

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 ...
Read More

MySQL FORMAT Function | Format a Number after Rounding

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 ...
Read More

MySQL group_concat Function Explained

We already saw in our previous post that how MySQL Concat function works. Now Concat function concatenates different column values of the same row. In order to concatenate the values of a particular column of different rows, you may use the MySQL group_concat Function. In this article, I will discuss ...
Read More

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 ...
Read More

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 ...
Read More

MySQL LCASE Function | Convert Text to Lowercase

MySQL LCASE is an inbuilt Function in MySQL. It converts a text to lowercase in MySQL. In this article, we will discuss the MySQL LCASE Function. Also, we will discuss a few examples of using it. This function is synonymous to MySQL LOWER Function. Syntax LCASE (string) Parameters The Function ...
Read More

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 ...
Read More

MySQL LENGTH Function | Length of String

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 ...
Read More

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, ...
Read More

MySQL LOWER Function | Convert Text to Lowercase

MySQL LOWER is an inbuilt Function in MySQL. It converts a text to lowercase in MySQL. In this article, we will discuss the MySQL LOWER Function. Also, we will discuss a few examples of using it. This function is synonymous to MySQL LCASE Function. Also, you can convert text to ...
Read More

MySQL LPAD Function | Pad a String with Another String

MySQL LPAD is an inbuilt function in MySQL. It pads a string with specified characters on the left up to a given length. In this article, we will discuss the MySQL LPAD Function. Also, we will discuss a few examples of using it. You can also read about MySQL RPAD ...
Read More

MySQL LTRIM Function | Remove Leading Spaces from String

LTRIM is an inbuilt Function in MySQL which removes unwanted leading spaces from a string in MySQL. Data present in tables might not always what we expect. There can be unwanted spaces leading the strings. LTRIM Function removes those unwanted spaces. In this article, we will discuss the MySQL LTRIM ...
Read More

MySQL MID Function | Extract Substring from String

MySQL MID is an inbuilt string Function in MySQL. It is used to extract a substring from a string. We will discuss the MySQL MID Function in this article. Also, we will discuss a few examples to demonstrate it's usage. Syntax MID(string, start, length) Parameters The MySQL MID Function need ...
Read More

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, ...
Read More

MySQL REPEAT Function | Repeat Strings

MySQL REPEAT is an inbuilt function in MySQL. It repeats a string for a specified number of times. Both the string and the number are the arguments to the function. In this article, we will discuss the MySQL REPEAT Function. Also, we will discuss a few examples of using it ...
Read More

MySQL Replace Function | Replace Substring in a String

MySQL provides a useful string function called Replace that allows you to replace a string in a column of a table by another. In this article, we will discuss the MySQL Replace Function which can replace all occurrences of a sub-string by a new sub-string in a string. Also, we ...
Read More

MySQL REVERSE Function | Reverse String

Reverse Function reverses a string and returns the result. It is an inbuilt Function which works from MySQL 4.0 onwards. It is a useful function that reverses the input string in MySQL. In this article, we will discuss the MySQL Reverse Function. Also, we will discuss a few examples of ...
Read More

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 ...
Read More

MySQL RPAD Function | Pad a String with Another String

MySQL RPAD is an inbuilt function in MySQL. It pads a string with specified characters on the right up to a given length. In this article, we will discuss the MySQL RPAD Function. Also, we will discuss a few examples of using it. You can also read about MySQL LPAD ...
Read More

MySQL RTRIM Function | Remove Trailing Spaces from String

RTRIM is an inbuilt Function in MySQL which removes unwanted trailing spaces from a string in MySQL. Data present in tables might not always what we expect. There can be unwanted spaces trailing the strings. RTRIM Function removes those unwanted spaces. In this article, we will discuss the MySQL RTRIM ...
Read More

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 ...
Read More

MySQL STRCMP Function | Compare Two Strings

MySQL STRCMP is an inbuilt Function in MySQL. It compares two strings and returns 0 if both of them are the same. Also, it returns -1 if the first string is smaller than the second and returns 1 on the other way round according to the sort order. In this ...
Read More

MySQL SUBSTR Function | Extract Substring from String

MySQL SUBSTR is an inbuilt string Function in MySQL. It is used to extract a substring from a string. We will discuss the MySQL SUBSTR Function in this article. Also, we will discuss a few examples to demonstrate it's usage. Syntax SUBSTR(string, start, length) Parameters The MySQL SUBSTR Function need ...
Read More

MySQL Substring Function | Extract Substring from String

MySQL SUBSTRING is an inbuilt string Function in MySQL. It is used to extract a substring from a string. We will discuss the MySQL SUBSTRING Function in this article. Also, we will discuss a few examples to demonstrate it's usage. Syntax SUBSTRING(string, start, length) Parameters The MySQL Substring Function need ...
Read More

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 ...
Read More

MySQL TRIM Function | Remove Unwanted Characters

TRIM is an inbuilt Function in MySQL which removes unwanted leading and trailing characters from a string in MySQL. Data present in tables might not always what we expect. There can be unwanted characters or spaces leading or trailing in the strings. TRIM Function is used to remove those unwanted ...
Read More

MySQL UCASE Function | Convert Text to Uppercase

MySQL UCASE is an inbuilt Function in MySQL. It converts a text to uppercase. In this article, we will discuss the MySQL UCASE Function. Also, we will discuss a few examples of using it. This function is synonymous to MySQL UPPER Function. Syntax UCASE (string) Parameters The Function expects only ...
Read More

MySQL UPPER Function | Convert Text to Uppercase

MySQL UPPER is an inbuilt Function in MySQL. It converts a text to uppercase. In this article, we will discuss the MySQL UPPER Function. Also, we will discuss a few examples of using it. This function is synonymous to MySQL UCASE Function. Also, you can convert text to lowercase using ...
Read More