Select all rows from the 'logs' table where the 'message' column contains the pattern 'error' in a case-insensitive manner.
CREATE TABLE logs (id INTEGER, message VARCHAR); INSERT INTO logs (id, message) VALUES (1, 'An error occurred'), (2, 'No issues found'), (3, 'ERROR: System failure');
```sql
SELECT * FROM logs WHERE LOWER(message) LIKE '%error%';
```
```sql
SELECT * FROM logs WHERE LOWER(message) LIKE '%error%';
```