Search for string in multiline records

I'm trying to extract every row of a table whose column (let's call it "paragraph") matches a search string. The "paragraph" entry can (and always will) contain newlines. How can I select the correct rows?

For example, let's say I'm searching for every record that contains the word "jumps" in its "paragraph" column. How would I go about matching the following text:

The quick brown

fox jumps over

the lazy dog

I'm using sqlite and it doesn't have regex support.