In MySQL, you can use NOT LIKE to perform a negation of the LIKE operator. In other words, NOT LIKE returns the opposite result to LIKE.
If the string matches the pattern provided, the result is 0, otherwise it’s 1.
The pattern doesn’t necessarily need to be a literal string. This function can be used with string expressions and table columns.
In MySQL, the LIKE operator performs pattern matching using an SQL pattern.
If the string matches the pattern provided, the result is 1, otherwise it’s 0.
The pattern doesn’t necessarily need to be a literal string. This function can be used with string expressions and table columns.
In MySQL, the RLIKE operator is used to determine whether or not a string matches a regular expression. It’s a synonym for REGEXP_LIKE().
If the string matches the regular expression provided, the result is 1, otherwise it’s 0.
In MySQL, the SUBSTR() function returns a substring starting from the specified position.
Both SUBSTR() and MID() are synonyms of SUBSTRING().
In MySQL, the MID() function returns a substring starting from the specified position.
Both MID() and SUBSTR() are synonyms of SUBSTRING().
In MySQL, the RAND() function allows you to generate a random number. Specifically, the function returns a random floating-point value v in the range 0 <= v < 1.0.
You can also influence the random number by providing a seed value as an argument.
In MySQL, the JSON_SET() function inserts or updates values in a JSON document and returns the result.
You provide the JSON document as the first argument, followed by the path to insert into, followed by the value to insert. You can provide multiple path/value pairs if you need to update multiple values.
When working with JSON and MySQL, sometimes you might need to escape strings so that their quote characters don’t interfere with the interpretation of the JSON document. In such cases, you can use the JSON_QUOTE() function to escape potentially problematic strings.
JSON_QUOTE() is used to produce a valid JSON string literal that can be included in a JSON document. For example, you might want an element in an array to have the text null as a string literal, rather than having an actual null value. This function can be used to ensure that the text is added as a string literal, rather than a null value.
To use it, simply call the function while passing in the string.
The MySQL MIN() function is an aggregate function that returns the minimum value from an expression.
Typically, the expression would be a range of values returned as separate rows in a column, and you can use this function to find the minimum value from the returned rows. If there are no matching rows, MIN() returns NULL.
For example, you can use this function to find out which city has the smallest population out of a list of cities.