Did Shakespeare talk too much about love? At FROSTY_FRIDAY() we’re feeling rather grumpy and want to know whether we’re right in saying that the great playwright might’ve been a bit overly emotional.
Luckily, Snowflake has released the SEARCH() function for this very exact and specific use case.
Here we have 18 Shakespeare quotes:
Quotes
with quotes as (
select 'Better three hours too soon than a minute too late.' as quote
union all
select 'My words fly up, my thoughts remain below. Words without thoughts never to heaven go.'
union all
select 'Brevity is the soul of wit.'
union all
select 'Love looks not with the eyes, but with the mind; and therefore is winged Cupid painted blind'
union all
select 'Suit the action to the word, the word to the action.'
union all
select 'No legacy is so rich as honesty.'
union all
select 'All that glitters is not gold.'
union all
select 'Love all, trust a few, do wrong to none.'
union all
select 'Our doubts are traitors and make us lose the good we oft might win by fearing to attempt.'
union all
select 'Some are born great, some achieve greatness, and some have greatness thrust upon them'
union all
select 'To be or not to be: that is the question'
union all
select 'All the world’s a stage'
union all
select 'What, my dear Lady Disdain! Are you yet living?'
union all
select 'If music be the food of love, play on'
union all
select 'I cannot tell what the dickens his name is'
union all
select 'Shall I compare thee to a summer’s day?'
union all
select 'What’s in a name? A rose by any name would smell as sweet'
union all
select 'A horse! A horse! My kingdom for a horse!'
)
Use the SEARCH() function to tell us if the word ‘love’ appears in the quote. Your output should look like the below:
givfiorito says
Quick and easy!