Determine if a word or phrase is an isogram.
An isogram (also known as a "non-pattern word") is a word or phrase without a repeating letter, however spaces and hyphens are allowed to appear multiple times.
Examples of isograms:
The word isograms, however, is not an isogram, because the s repeats.
You will be provided a table named "isogram". The first column, "phrase", contains some text. You need to determine if the phrase is an isogram. Update the second column, "is_isogram", with an integer value:
SQLite comparison operations return boolean values as 0/1 numbers
$ sqlite3
sqlite> .mode table
sqlite> SELECT 1 < 2 AS "true", 1 > 2 AS "false";
+------+-------+
| true | false |
+------+-------+
| 1 | 0 |
+------+-------+
Edit via GitHub
Sign up to Exercism to learn and master SQLite with 21 exercises, and real human mentoring, all for free.