user: ### NOW ANSWER:
Question: what is the soap opera when the duration is 18 years and the character is Miley Byrne?
Columns: ['Actor', 'Character', 'Soap Opera', 'Years', 'Duration']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Tom Jordon', 'Charlie Kelly', 'Fair City', '1989—', '25 years']
SQL:

assistant: SELECT "Soap Opera" FROM "Table" WHERE "Duration" = '18 years' AND "Character" = 'Miley Byrne';