Article search/filter

[rzbrk]

Implement article search and filter

• Search for phrases in article text or notes
• Show articles linked to a list of categories
• Show articles linkes to a list of tags
• Show articles created or edited in a specific time period
• Show draft/published/unpublished articles

[rzbrk]

SQL Text search example:

select art_id,alias from articles where lower(intr_text) like lower('%perlpress%') or lower(full_text) like lower ('%perlpress%');

http://stackoverflow.com/questions/3936967/mysql-case-insensitive-select