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.