Downloaded database & need assistance with queries

I have 0 experience with SQL and could use some assistance with the queries, please.

I downloaded a deleted fanfiction database and want to search for specific keywords in multiple columns. (There’s a way to retrieve the deleted fics.)

For example, say I wanted to find time travel stories set in the Marvel Cinematic Universe.

In the database MCU would be under Category, and I’d want to find the phrases “time travel” or “time travel fix-it” under the Genre or Summary columns.

How would I write this kind of query? Thanks in advance!