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.