How SQLite Random() Works

Posted on May 19, 2020June 28, 2020 by Ian

The SQLite random() function returns a pseudo-random integer between -9223372036854775808 and +9223372036854775807.

A pseudo-random number is a number that appears to be random, but is not truely random. A pseudo-random number is not truely random because its value was generated by a known seed. However, a pseudo-random number will appear to be random if the user has no knowledge of the seed or algorithm that created it.

Therefore, pseudo-random numbers are often considered good enough for many applications.

Continue reading →

How SQLite Ifnull() Works

Posted on May 18, 2020May 28, 2020 by Ian

The SQLite ifnull() function allows you to replace NULL values with another value.

It takes two arguments, and it returns a copy of its first non-NULL argument, or NULL if both arguments are NULL.

The ifnull() function is equivalent to coalesce() with two arguments.

Continue reading →

How Coalesce() Works in SQLite

Posted on May 18, 2020May 28, 2020 by Ian

In SQLite, the coalesce() function returns a copy of its first non-NULL argument, or NULL if all arguments are NULL.

It’s similar to the ifnull() function, except that coalesce() accepts more than two arguments (ifnull() only accepts two arguments).

Continue reading →

How SQLite Trim() Works

Posted on May 17, 2020May 28, 2020 by Ian

The SQLite trim() function trims whitespace or other characters from both sides of a string.

The function returns a copy of the string that you provide as an argument, with either whitespace, or other characters as specified, trimmed from both sides.

Continue reading →

How SQLite Rtrim() Works

Posted on May 17, 2020May 28, 2020 by Ian

In SQLite, the rtrim() function enables you to trim whitespace or other characters from the right part of a string.

It returns a copy of the string that you provide as an argument, with the right part trimmed of either whitespace, or other characters as specified.

Continue reading →

How SQLite Ltrim() Works

Posted on May 17, 2020May 28, 2020 by Ian

The SQLite ltrim() function trims whitespace or other characters from the left of a string.

More precisely, it returns a copy of the string that you provide as an argument, with the left part trimmed of either whitespace, or other characters that you specify.

Continue reading →

How to Change the Command Line Prompt in SQLite

Posted on May 16, 2020May 28, 2020 by Ian

If you’ve ever used the SQLite command line shell, you’re probably familiar with the default command line prompt. Actually, there are two prompts:

The default main prompt looks like this: sqlite>
The default continuation prompt looks like this: ...>

If you don’t like these prompts, you can always change them with the .prompt dot command.

This article provides a quick demonstration on how to change these prompts.

Continue reading →

How to Make SQLite’s LIKE Operator Case-Sensitive

Posted on May 15, 2020May 28, 2020 by Ian

By default, the SQLite LIKE operator is case-insensitive for ASCII characters. This means it will match uppercase and lowercase characters, regardless of which case you use in your pattern.

However, there is a technique you can use to make it case-sensitive.

Continue reading →

How the LIKE Operator Works in SQLite

Posted on May 14, 2020May 28, 2020 by Ian

In SQLite, you can use the LIKE operator in your queries to do a pattern matching comparison.

For example, you can add it to your WHERE clause in order to return only rows that match a given pattern.

However, adding it to the WHERE clause isn’t the only way you can use the LIKE operator. You can also use it to return a boolean value.

Continue reading →

SQLite Like() Function with Examples

Posted on May 14, 2020May 28, 2020 by Ian

The SQLite like() function enables you to compare a string against a given pattern. You can also specify an escape character if required.

You can use the like() function as an alternative to the LIKE operator (which enables you to run the Y LIKE X [ESCAPE Z] expression).

Continue reading →

Database.Guide

Category: SQLite

How SQLite Random() Works

How SQLite Ifnull() Works

How Coalesce() Works in SQLite

How SQLite Trim() Works

How SQLite Rtrim() Works

How SQLite Ltrim() Works

How to Change the Command Line Prompt in SQLite

How to Make SQLite’s LIKE Operator Case-Sensitive

How the LIKE Operator Works in SQLite

SQLite Like() Function with Examples