How to find the number of times a character occurs in a string using SQL

Counting the number of occurrences of a character in a string can be useful in performing language processing and fuzzy searching. This tutorial will provide examples in SQL for different database engines.
Continue reading “How to find the number of times a character occurs in a string using SQL”

How to return random rows from a table in SQL

Learn how to return a specific set of random records from a table. It’s an effective way to gain user interest in articles they might not be aware of or a method of displaying different textual content on pages to perform marketing analysis on what content is most effective.

Learn how to return a specific set of random records from a table. It’s an effective way to gain user interest in articles they might not be aware of or a method of displaying different textual content on pages to perform marketing analysis on what content is most effective. Continue reading “How to return random rows from a table in SQL”