Sunbelt Computer Software

PL/B Language Development and Support

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

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 ?