Help for this page

Select Code to Download


  1. or download this
    CREATE VIRTUAL TABLE contacts USING fts5(name, department);
INSERT INTO contacts (name,department) VALUES ('John Doe','Perl');
INSERT INTO contacts (name,department) VALUES ('Larry Wall','Perl');
INSERT INTO contacts (name,department) VALUES ('Gloria Wall','Perl');
  2. or download this
    $c->sqlite->db->query(
  q{ SELECT rowid,name,department FROM contacts WHERE name MATCH ? },
  $c->stash('query') )->arrays );