SQL – MySQL MINUTE() Function
May 7, 2023
The MySQL MINUTE() function returns the minute part of a time/datetime (from 0 to 59).
SQL – MySQL MID() Function
June 13, 2023
The MySQL MID() function extracts a substring from a string, starting at any position from the beginning or end of the string.
SQL – MySQL MOD() Function
April 1, 2023
The MySQL MOD() function returns the remainder of a number divided by another number.
SQL – MySQL MONTH() Function
May 8, 2023
The MySQL MONTH() function returns the month part for a given date (a number from 1 to 12).
SQL – MySQL MONTHNAME() Function
May 9, 2023
The MySQL MONTHNAME() function returns the name of the month for a given date.
SQL – MySQL NOW() Function
May 10, 2023
The MySQL NOW() function returns the current date and time as “YYYY-MM-DD HH:MM:SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL NULLIF() Function
June 12, 2023
The MySQL NULLIF() function compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned.
SQL – MySQL PERIOD_ADD() Function
May 11, 2023
The MySQL PERIOD_ADD() function adds a specified number of months to a period and will return the result formatted as YYYYMM.
SQL – MySQL PERIOD_DIFF() Function
May 12, 2023
The MySQL PERIOD_DIFF() function returns the difference between two periods (both periods should be in the same format). The result will be in months.
SQL – MySQL POSITION() Function
June 13, 2023
The MySQL POSITION() function returns the position of the first occurrence of a case-insensitive substring in a string.
SQL – MySQL POW() Function
April 4, 2023
The MySQL POW() function returns the value of a number raised to the power of another number.
SQL – MySQL POWER() Function
June 30, 2023
The MySQL POWER() function returns the value of a number raised to the power of another number.
SQL – MySQL QUARTER() Function
May 13, 2023
The MySQL QUARTER() function returns the quarter of the year for a given date value (a number from 1 to 4).
SQL – MySQL RADIANS() Function
April 4, 2023
The MySQL RADIANS() function converts a degree value (expressed as a positive or negative number) into radians.
SQL – MySQL RAND() Function
June 26, 2023
The MySQL RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
SQL – MySQL REPEAT() Function
June 13, 2023
The MySQL REPEAT() function repeats a string as many times as specified.
SQL – MySQL REPLACE() Function
June 13, 2023
The MySQL REPLACE() function replaces all case-sensitive occurrences of a substring within a string, with a new substring.
SQL – MySQL REVERSE() Function
June 13, 2023
The MySQL REVERSE() function reverses a string and returns the result.
SQL – MySQL RIGHT() Function
June 13, 2023
The MySQL RIGHT() function extracts a number of characters from a string, starting from right.
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
Why 1SMARTchicken?
This site was built and is maintained to benefit my autistic son.
See More →
See More →
Thanks for your support!
Books
All are affiliate links. Thank you for your support!
