#mysql function

MySQL UNION Operator

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

Each SELECT statement within UNION must have the same number of columns

The columns must also have similar data types

The columns in each SELECT statement must also be in the same order

Example:

Basic Query:

SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2;

Query…

MySQL LIKE Operator

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

There are  % wildcards often used in conjunction with the LIKE operator:

% – The percent sign represents zero, one, or multiple characters

_ – The underscore represents a single character

  SELECT column1, column2, … FROM table_name WHERE columnN LIKE pattern;

Here are some examples…

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 calculate the sum of a set of values or an expression.

Syntax for SUM function would be as below:

SELECT SUM(column_name) FROM table_name WHERE condition;

You can also use distinct value while sum function

SELECT SUM(distinct column_name) FROM table_name W…

MySQL MIN() and MAX() Functions

MySQL MIN() and MAX() Functions

  The MIN() function returns the smallest value of the selected column and the MAX() function returns the largest value of the selected column.

MIN() Syntax SELECT MIN(column_name) FROM table_name WHERE condition; MAX() Syntax SELECT MAX(column_name) FROM table_name WHERE condition;

MySQL TRIM() function returns a string after removing all prefixes or suffixes from the given string. Syntax TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM ] str) Arguments Name Description BOTH Indicates that prefixes from both left and right are to be removed. LEADING Indicates that only leading prefixes are to be removed. TRAILING Indicates that only trailing prefixes are to be removed.…

MySQL has a RAND function that can be invoked to produce random numbers between 0 and 1: mysql> SELECT RAND( ), RAND( ), RAND( ); +——————+—————–+——————+ | 0.45464584925645 | 0.1824410643265 | 0.54826780459682 | +——————+—————–+——————+ 1 row in set (0.00 sec) When invoked with an integer argument, RAND( ) uses that value to seed the random number generator. Each time you seed the generator with a…

MySQL LOCATE() returns the position of the first occurrence of a string within a string. Both of these strings are passed as arguments. An optional argument may be used to specify from which position of the string (i.e. string to be searched) searching will start. If this position is not mentioned, searching starts from the beginning. Syntax: LOCATE(substr,str) or LOCATE (search str, str,…