note-cli/raw-sql.sql.example at main · didvc/note-cli · GitHub

Sitelet https://github.com/didvc/note-cli/blob/main/raw-sql.sql.example

6 lines (6 loc) · 200 Bytes

SELECT note.id, note.header, note.content from note
    WHERE LOWER(note.header) REGEXP ?
    AND LOWER(note.content) REGEXP ?
    AND LOWER(note.entire_note) REGEXP ?
    order by id asc
    LIMIT ?