For an assignment, we are doing select statements using Shakespeare's works in PG Admin. I must find which character, and in what work, said a specific phrase. I'm stuck with the following code:
select workid, charid from paragraph where plaintext like 'rose'
In which I'm trying to find who said "A rose by any other name would smell as sweet." Any tips?