In this tutorial, we will study the MySQL REPLACE() function. Sometimes, you may have to change the value of a substring within a string. This is where the MySQL REPLACE() function comes into the picture. The REPLACE() function is used to replace all the occurrences of a substring, with a new string. The REPLACE() function …
MySQL REPLACE() – Edit Strings and Replace Values in MySQL Read More »
In this tutorial, we will study the MySQL POSITION() function. Suppose you want to find where a substring value is located in a string. Operations like these can be common for string operations and manipulations on data in tables. This is where we use the MySQL POSITION() function. The MySQL POSITION() is used to find …
MySQL POSITION() – Find the position of a substring in a string in MySQL Read More »
In this tutorial, we will study the MySQL UPPER() and UCASE() functions. Just like LOWER() and LCASE(), UPPER() and UCASE() are synonyms of each other in MySQL. The UPPER() and UCASE() functions are string functions that are used to convert a string to uppercase alphabets. It is important to note that if there are any …
MySQL UPPER() and UCASE() – How to convert text to uppercase in MySQL? Read More »
In this tutorial, we will study the MySQL LOWER() and LCASE() functions. LOWER() and LCASE() are synonyms of each other in MySQL. They have a different name but do the same thing. The LOWER() and LCASE() functions are string functions that are used to convert a string to lower-case alphabets. For instance, if you have …
MySQL LOWER() and LCASE() – How to convert text to lowercase in MySQL? Read More »
In this tutorial, we will study the MySQL CHAR_LENGTH() function. The CHAR_LENGTH() function is used to return the length of the string as the number of characters in it. The CHARACTER_LENGTH() function is the same as CHAR_LENGTH() function. Both of them do the same thing i.e., returning the number of characters in a string. For …
MySQL CHAR_LENGTH() – How to find the number of characters in a string? Read More »
In this tutorial, we will study the MySQL LENGTH() function. While working with tables in MySQL, there may be a situation in which you may want to calculate the length of a value in a column. For this purpose, MySQL provides us with the LENGTH() function. The MySQL LENGTH() function returns the length of a …
MySQL LENGTH() Function – How to measure the length of strings in bytes? Read More »
In this tutorial, we will learn about the MySQL REVERSE() function. MySQL REVERSE() function is a string function that is used to reverse a given argument and return the result. Suppose you have 123 as an argument in the REVERSE() function, then the result returned would be 321. The REVERSE() function is usually used with …
MySQL REVERSE() Function – How to reverse values in MySQL? Read More »
In a previous tutorial, we studied the MySQL CONCAT() function. Building on that, this tutorial will focus on the MySQL CONCAT_WS() function. The MySQL CONCAT_WS() function is used to concatenate or combine two or more expressions with a separator. This separator is added between the expressions and then we get our concatenated string as our …
In this tutorial, we will learn about the MySQL CONCAT() function. Suppose you have an Employee table that has separate columns for the first name and the last name of the employee. What if you had to display the full name (first name + last name) of the employee in MySQL? Such a query would …
In this tutorial, we will learn about the MySQL ASCII() function. The American Standard Code for Information Interchange, or ASCII, is a character encoding standard for electronic communication. Since computers can only understand numbers, the ASCII numeric codes are used to represent text in computers. You may read more about ASCII over here. The MySQL ASCII() …
MySQL ASCII() Function – How to find ASCII values in MySQL? Read More »