Repeated word in tickets

Repeated word in tickets

Some tickets contain words that were accidentally typed twice. Return ticket_id and body for tickets where the same standalone word appears twice in a row with one or more whitespace characters between the copies; compare words case-insensitively. Sort the rows by ticket_id ascending.

Row order matters

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid