Cacher is the code snippet organizer for pro developers

CREATE VIEW view_s
as SELECT  id_str, text, created_at
FROM gh_rc
where year=2013 AND (month=2 AND day>=15 OR month=3 AND day<=15) 
AND lower(text) RLIKE "(matthew mcconaughey|matthew david mcConaughey)";