Learn how the MAKE_SET() function works in MySQL, including syntax, usage, and examples.
Learn how the LTRIM() function works in MySQL, including syntax, usage, and examples.
Learn how the LPAD() function works in MySQL, including syntax, usage, and examples.
Learn how the LOWER() function works in MySQL, including syntax, usage, and examples.
Learn how the LOCATE() function works in MySQL, including syntax, usage, and examples.
Learn how the LOAD_FILE() function works in MySQL, including syntax, usage, and examples.
Learn how the LIKE operator works in MySQL, including syntax, usage, and examples.
Learn how the LEFT() function works in MySQL, including syntax, usage, and examples.
Learn how the LCASE() function works in MySQL, including syntax, usage, and examples.
Learn how the INSTR() function works in MySQL, including syntax, usage, and examples.
This article provides an in-depth look at the MySQL FROM_BASE64() function, including its syntax, usage, and practical examples.
This article provides an in-depth look at the MySQL EXPORT_SET() function, including its syntax, usage, and practical examples.
This article provides an in-depth look at the MySQL CHARACTER_LENGTH() function, including its syntax, usage, and practical examples.
This article provides an in-depth look at the MySQL NOT RLIKE operator, including its syntax, usage, and practical examples.
This article provides an in-depth look at the MySQL NOT REGEXP operator, including its syntax, usage, and practical examples.
This article provides an in-depth look at the MySQL NOT LIKE operator, including its syntax, usage, and practical examples.
This article provides an in-depth look at the MySQL GROUP_CONCAT() function, including its syntax, usage, and practical examples.
This article provides an in-depth look at the MySQL ABS() function, including its syntax, usage, and practical examples.
This article explains the causes of MySQL Warning 1287 and provides solutions to fix it when using the BINARY operator.
This article explains the causes of Error 3942 in MySQL and provides solutions to fix it when using the VALUES statement.
This article explains the causes of Error 1250 in MySQL and provides solutions to fix it when using UNION.
This article explains the causes of Error 1222 in MySQL and provides solutions to fix it when using the UNION operator.
This article explains the causes of Error 1136 in MySQL and provides solutions to fix it when using the VALUES statement.
This article explains the causes of Error 1136 in MySQL and provides solutions to fix it when inserting data.
This article explains the causes of Error 1054 in MySQL and provides solutions to fix it when using UNION.
The YEARWEEK() function in MariaDB is a date function that returns the year and week number for a given date.
YEARWEEK()
The YEAR() function in MariaDB is a date function that extracts the year part from a given date.
YEAR()
The WITHIN() function in MariaDB is a spatial function used to determine whether a geometry is within another geometry.
WITHIN()
The WEIGHT_STRING() function in MariaDB is used to return the weight string of a string.
WEIGHT_STRING()
The WEEKOFYEAR() function in MariaDB is used to return the week number for a given date.
WEEKOFYEAR()
The WEEKDAY() function in MariaDB is a date function that returns the index of the day of the week for a given date.
WEEKDAY()
The MariaDB WEEK() function is one such feature that allows users to extract the week number from a date.
WEEK()
The MariaDB VERSION() function is quite useful for users who need to know the version of the MariaDB server they are working with.
VERSION()
In MariaDB, the VARIANCE() function is used to calculate this measure for a set of numbers.
VARIANCE()
The VAR_SAMP() function in MariaDB is used to calculate the sample variance of a set of values.
VAR_SAMP()
The VAR_POP() function in MariaDB is used to calculate the population variance of a set of values.
VAR_POP()
The UUID() function in MariaDB is used to generate a universally unique identifier (UUID), which is a 128-bit number that is designed to be unique across space and time.
UUID()
The REGEXP() function is a string function that returns 1 if a string matches a given regular expression pattern, or 0 otherwise.
REGEXP()
The UUID_SHORT() function in MariaDB is used to generate a 64-bit universally unique identifier (UUID).
UUID_SHORT()
The PointOnSurface() function is a built-in function in Mariadb that returns a point geometry that is guaranteed to lie on the surface of a given geometry.
PointOnSurface()
The REGEXP_SUBSTR() function is a string function that returns the substring that matches a given regular expression pattern in a subject string.
REGEXP_SUBSTR()
The UTC_TIMESTAMP() function in MariaDB returns the current date and time in the Coordinated Universal Time (UTC) time zone.
UTC_TIMESTAMP()
The PointN() function is a built-in function in Mariadb that returns the N-th point of a linestring geometry.
PointN()
The REGEXP_REPLACE() function is a string function that returns a new string where the occurrences of a regular expression pattern are replaced by a specified replacement string in a subject string.
REGEXP_REPLACE()
The UTC_TIME() function in MariaDB is used to retrieve the current time in the UTC (Coordinated Universal Time) time zone.
UTC_TIME()
The PointFromWKB() function is a built-in function in Mariadb that returns a point geometry that represents a location in a two-dimensional space.
PointFromWKB()
The REGEXP_INSTR() function is a string function in Mariadb that returns the position of the first occurrence of a regular expression pattern in a string.
REGEXP_INSTR()
The UTC_DATE() function in MariaDB is used to retrieve the current date in the UTC (Coordinated Universal Time) time zone.
UTC_DATE()
The PointFromText() function is a built-in function in Mariadb that returns a point geometry that represents a location in a two-dimensional space.
PointFromText()
The RANK() function is a window function in Mariadb that returns the rank of a row within a partition of a result set.
RANK()