view · edit · sidebar · attach · print · history

Full-Text Search in SQlite from aips2sqlite

  1. sqlite> .headers on
  2. sqlite> .mode csv
  3. sqlite> .output test.csv
  4. Anzahl: SELECT count(title) FROM amikodb WHERE content like '%intravenös%';
  5. Name: SELECT title FROM amikodb WHERE content like '%intravenös%';
  6. sqlite> .output stdout`
view · edit · sidebar · attach · print · history
Page last modified on March 03, 2014, at 03:47 PM