In SQLite, iif() is a conditional function that returns the second or third argument based on the evaluation of the first argument.
It’s logically equivalent to CASE WHEN X THEN Y ELSE Z END.
iif() is an abbreviation for Immediate IF.
The iif() function was introduced in SQLite 3.32.0, which was released on 22 May 2020.
In SQLite, the char() function returns a string based on the unicode code points provided as arguments.
You can provide one or more arguments, each of which is a unicode code point. The function then returns a string based on those code points.
Continue readingSQLite has a function called last_insert_rowid() that returns the ROWID of the last row insert from the database connection which invoked the function.
The SQLite length() function returns the number of characters in a string, number, or blob.
If there are any NUL characters, it returns the number of characters before the first NUL character.
Continue readingThe SQLite quote() function allows you to escape a string so that it’s suitable for inclusion in an SQL statement.
Strings are surrounded by single-quotes with escapes on interior quotes.
BLOBs are encoded as hexadecimal literals.
Note that strings with embedded NUL characters cannot be represented as string literals in SQL. If you include strings with embedded NUL characters, the returned string literal is truncated prior to the first NUL.
Continue readingSQLite has a function called nullif() and another function called ifnull(), each of which serve a different purpose.
nullif() allows you to treat certain values as NULL. You can think of it as “return NULL if …”.ifnull() allows you to replace NULL values with another value. You can think of it as “if NULL, then …”.So they basically do the opposite of each other. One replaces NULL values with another value, and the other replaces another value with NULL.
Continue readingThe SQLite typeof() function allows you to determine the data type of an expression.
An expression can be one of the following data types:
The SQLite randomblob() function returns a blob containing pseudo-random bytes.
The number of bytes is determined by its argument. If its argument is less than 1 then a 1-byte random blob is returned.
Continue readingThe SQLite replace() function enables us to replace one string (or part of a string) with another string.
The way it works is that you provide three arguments; the string that contains the substring to replace, the substring within that string to replace, and the string to replace it with.
Continue readingIn SQLite, you can use the unicode() function to return the unicode code point for a given character.
The way it works is that it returns the unicode code point for the first character of the string that you provide.
Continue reading