In this tutorial, we will study the MySQL REPEAT() function. Suppose you have a string and for it to be presentable in your output, you want the string to be repeated a specific number of times. This is where the MySQL REPEAT() function comes into play. REPEAT() is used to repeat a string or an …
In this tutorial, we will learn about the MySQL EXP() function. While studying maths, you must have come across the exponential constant e. The exponential constant, given by the symbol e, is an important mathematical constant whose value is approximately 2.718. It is the base of natural logarithms. The exponential constant finds applications in maths …
MySQL EXP() – How to find the power of the exponential constant e in MySQL? Read More »
In this tutorial, we will learn about MySQL LPAD() and MySQL RPAD() functions in MySQL. Padding is the process of adding some unnecessary material in your strings, often to meet a minimum word count. Padding in MySQL can be very useful in formatting the output of a query. MySQL provides us with two padding functions …
MySQL LPAD() and RPAD() – Add Arbitrary Characters to a String Read More »
In this tutorial, we will learn about the MySQL FIND_IN_SET() function. The FIND_IN_SET() function is used to return the position of a string or a number from a list of strings or numbers. Suppose we have a list of strings and we want to find the position of ‘Hello’ in the string list. If ‘Hello’’ …
MySQL FIND_IN_SET() – Find Substring Positions using MySQL Read More »
In this tutorial, we will study about the MySQL ROUND() and MySQL TRUNCATE() functions. You must have studied rounding off to a certain decimal place while studying high school maths. Since it is such a common mathematical operation, MySQL provides us with the ROUND() function. The MySQL ROUND() function is used to round off a …
In this tutorial, we will learn about the MySQL FORMAT() function. In the real world, when you have to write one hundred thousand in figures, you write it as 100,000 and not as 100000. You use some form of formatting by adding the comma to make the number more readable. You must have observed so …
MySQL FORMAT() – How to format numbers in MySQL? Read More »
In this tutorial, we will learn about the MySQL LTRIM(), RTRIM() and TRIM() functions. Data in tables might not always be clean. By not being clean, I mean the values may have excessive spaces or other jargon or no value at all. Suppose you have a table containing Country names. When you take a look …
In this tutorial, we will learn about the MySQL FLOOR() and CEIL() functions. The FLOOR() function accepts a number or a numeric expression as an argument and returns the largest integer value that is less than or equal to the argument. For instance, if you pass 23.7 in FLOOR(), it will return you the largest …
In this tutorial, we will learn about the MySQL ABS() and the MySQL SIGN() functions. The ABS() function is used to find the absolute value of a number. The absolute value of a number is the non-negative value of the number. MySQL ABS() disregards the sign of a number and returns the result as a …
In this tutorial, we will study the MySQL PI() function. While studying maths in high school, you must have come across the value of 𝜋 known as Pi. The value of Pi is 22/7 or 3.142 up to three decimal places. Pi is used in a variety of mathematical calculations – geometry, calculus, and physics. …
MySQL PI() – Calculating Pi Value in MySQL [Simple Examples] Read More »