mysql function

MySQL UNION Operator The UNION operator is used to combine the result-set of two or more SELECT statements. Each SELECT

MySQL LIKE Operator The LIKE operator is used in a WHERE clause to search for a specified pattern in a

MySQL SUM function The SUM() function returns the total sum of a numeric column. The SUM() function is an aggregate function that allows you to

MySQL AVG() function AVG function to calculate the average value of a set of values or an expression. The AVG() function

MySQL count function The COUNT() function returns the number of rows that matches a specified criteria. COUNT function to count the

MySQL MIN() and MAX() Functions   The MIN() function returns the smallest value of the selected column and the MAX()

MySQL TRIM() function returns a string after removing all prefixes or suffixes from the given string. Syntax TRIM([{BOTH | LEADING

MySQL has a RAND function that can be invoked to produce random numbers between 0 and 1: mysql> SELECT RAND(

MySQL LOCATE() returns the position of the first occurrence of a string within a string. Both of these strings are

Description: MySQL LENGTH() returns the length of a given string. Syntax: LENGTH (str) Argument: Name      Description str