Discover published sets by community

Purpose: Converts one data type into another. Basic Syntax: SELECT CAST(expression AS data_type);

Purpose: Extracts a substring from a string. Basic Syntax: SELECT SUBSTRING(string, start, length);

Purpose: Combines two or more strings into one. Basic Syntax: SELECT CONCAT(string1, string2, ...);

Purpose: Converts a string to lowercase. Basic Syntax: SELECT LOWER(string);

Purpose: Returns the specified value if the expression is NULL, otherwise returns the expression. Basic Syntax: SELECT IFNULL(expression, value);

Purpose: Returns the smallest value in a column. Basic Syntax: SELECT MIN(column_name) FROM table_name;

Purpose: Calculates the difference between two dates. Basic Syntax: SELECT DATEDIFF(date1, date2);

Purpose: Converts a string to uppercase. Basic Syntax: SELECT UPPER(string);

Purpose: Returns the current time. Basic Syntax: SELECT CURTIME();

Purpose: Returns the first non-null value in a list. Basic Syntax: SELECT COALESCE(value1, value2, ...);

Purpose: Returns the largest value in a column. Basic Syntax: SELECT MAX(column_name) FROM table_name;

Purpose: Concatenates values from multiple rows into a single string. Basic Syntax: SELECT GROUP_CONCAT(column_name) FROM table_name;

Purpose: Returns the length of a string in bytes. Basic Syntax: SELECT LENGTH(string);

Purpose: Returns the current date. Basic Syntax: SELECT CURDATE();

Purpose: Adds together all values in a numeric column. Basic Syntax: SELECT SUM(column_name) FROM table_name;

Purpose: Returns the current date and time. Basic Syntax: SELECT NOW();

Purpose: Calculates the average value of a numeric column. Basic Syntax: SELECT AVG(column_name) FROM table_name;

Purpose: Returns the number of rows that match a specified criterion. Basic Syntax: SELECT COUNT(column_name) FROM table_name;

Purpose: Replaces all occurrences of a substring within a string with another substring. Basic Syntax: SELECT REPLACE(string, from_string, to_string);