Select all rows from the 'messages' table where the 'content' column contains the pattern 'urgent'.
CREATE TABLE messages (id INTEGER, content VARCHAR); INSERT INTO messages (id, content) VALUES (1, 'This is urgent'), (2, 'Not important'), (3, 'Urgent meeting');
```sql
SELECT * FROM messages WHERE content LIKE '%urgent%';
```
```sql
SELECT * FROM messages WHERE content LIKE '%urgent%';
```