scotrail

Custom SQL query returning 7 rows (hide)

with phrases as ( select key, value from json_each('["' || replace(:terms, ',', '","') || '"]') ), matches as (select phrases.key, phrases.value, ( select File from announcements where announcements.Transcription like '%' || trim(phrases.value) || '%' order by length(announcements.Transcription) limit 1 ) as File from phrases ), results as ( select key, announcements.Transcription, announcements.mp3 from announcements join matches on announcements.File = matches.File order by key ) select * from results

Query parameters

terms