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 »
In this tutorial, we will learn about the MySQL UNION operator. Suppose you encounter a situation in which you need to combine the results of two different queries. What would you do in such a case? MySQL provides us with the UNION operator for this purpose. MySQL UNION is used to combine the result-set of …
MySQL UNION – Show Combined Data From Multiple MySQL Tables Read More »
In this tutorial, we will learn about MySQL Alias. Suppose you have a query in which you are displaying the Department column and the COUNT(*) column which returns the number of employees in each department. To us programmers, we can understand what COUNT(*) means but when you present your results to someone who doesn’t understand …
MySQL Alias – An Easy Way to Setup Aliases in MySQL Read More »