By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select sqlite_version();
| sqlite_version() |
|---|
| 3.39.1 |
CREATE TABLE test ( title TEXT,naming_convention TEXT);
✓
INSERT INTO test (title)
VALUES
('Test row 1'),
('Testing row 2'),
('Delete row 3'),
('Untitled row 4'),
('Draft row 5'),
('Training row 6'),
('Shovel Test row 7');
✓
SELECT title FROM test
WHERE
(
LOWER(title) GLOB LOWER('*Test*')
OR LOWER(title) GLOB LOWER('*Testing*')
OR LOWER(title) GLOB LOWER('*Delete*')
OR LOWER(title) GLOB LOWER('*Untitled*')
OR LOWER(title) GLOB LOWER('*Draft*')
OR LOWER(title) GLOB LOWER('*Training*')
)
AND LOWER(title) NOT GLOB LOWER('*Shovel Test*')
| title |
|---|
| Test row 1 |
| Testing row 2 |
| Delete row 3 |
| Untitled row 4 |
| Draft row 5 |
| Training row 6 |
SELECT * FROM test;
| title | naming_convention |
|---|---|
| Test row 1 | null |
| Testing row 2 | null |
| Delete row 3 | null |
| Untitled row 4 | null |
| Draft row 5 | null |
| Training row 6 | null |
| Shovel Test row 7 | null |
UPDATE test
SET naming_convention = 'Persistent draft, test or training items older than 60 days'
WHERE
(
LOWER(title) GLOB LOWER('*Test*')
OR LOWER(title) GLOB LOWER('*Testing*')
OR LOWER(title) GLOB LOWER('*Delete*')
OR LOWER(title) GLOB LOWER('*Untitled*')
OR LOWER(title) GLOB LOWER('*Draft*')
OR LOWER(title) GLOB LOWER('*Training*')
)
AND LOWER(title) NOT GLOB LOWER('*Shovel Test*')
✓
SELECT * FROM test;
| title | naming_convention |
|---|---|
| Test row 1 | Persistent draft, test or training items older than 60 days |
| Testing row 2 | Persistent draft, test or training items older than 60 days |
| Delete row 3 | Persistent draft, test or training items older than 60 days |
| Untitled row 4 | Persistent draft, test or training items older than 60 days |
| Draft row 5 | Persistent draft, test or training items older than 60 days |
| Training row 6 | Persistent draft, test or training items older than 60 days |
| Shovel Test row 7 | null |