Posted to tcl by jnc at Tue Nov 08 09:35:52 GMT 2011view raw

  1. SELECT
  2. m.msgid, m.bucket, datetime(m.received) AS rx, m.size, m.attachment_count,
  3. u.fulladdr, m.subject AS subject,
  4. snippet(email) AS snippet, m.is_read
  5. FROM
  6. email AS e
  7. JOIN msg AS m ON (m.msgid=e.rowid)
  8. JOIN user AS u ON (m.from_userid=u.userid)
  9. WHERE
  10. email MATCH $keywords
  11. }