help/1.php

   1 <h1>Help for SQL expressions</h1>
   2
   3 <h2>Description</h2>
   4
   5 <p>The &laquo;SQL expression&raquo; is added to WHERE clause of
   6         view feed query. You can match on ttrss_entries table fields
   7         and even use subselect to query additional information. This
   8         functionality is considered to be advanced and requires basic
   9         understanding of SQL.</p>
  10
  11 <h2>Examples</h2>
  12
  13 <p>Match all unread articles:</p>
  14
  15 <pre>unread = true</pre>
  16
  17 <p>Matches all articles which mention Linux in the title:</p>
  18
  19 <pre>ttrss_entries.title like '%Linux%'</pre>
  20
  21 <p>See the database schema included in the distribution package for gruesome
  22 details.</p>
  23