jeudi 5 mai 2016

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.

Aucun commentaire:

Enregistrer un commentaire