1 <h1
>Help
for SQL expressions
</h1
>
5 <p
>The
«
;SQL expression
»
; 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
>
13 <p
>Match all unread articles
:</p
>
15 <pre
>ttrss_user_entries
.unread
= true</pre
>
17 <p
>Matches all articles which mention Linux in the title
:</p
>
19 <pre
>ttrss_user_entries
.title like
'%Linux%'</pre
>
21 <p
>See the database schema included in the distribution package
for gruesome