psql_history.sql

select * from irc_entries where message ILIKE '%bobs%';
select count(*) from irc_entries where message ILIKE '%bobs%';
select count(*) from irc_entries where message ILIKE '%base%';
select count(*) from irc_entries where message ILIKE '%loose%';
select count(*) from irc_entries where message ILIKE '%lostari%';
select * from irc_entries where message ILIKE '%lostari%';
select count(*) from irc_entries where message ILIKE '%morgan%';
select count(*) from irc_entries where message ILIKE '%kane%';
select count(*) from irc_entries where message ILIKE '%osku%';
select count(*) from irc_entries where message ILIKE '%osku%' AND message ILIKE '%kane%';
select count(*) from irc_entries where message ILIKE '%kankkunen%';
select count(*) from irc_entries where message ILIKE '%kepit%';
select count(*) from irc_entries where message ILIKE '%%';
select count(*) from irc_entries where message ILIKE '%yhdelle%';
select count(*) from irc_entries where message ILIKE '%yhelle%';
select count(*) from irc_entries where message ILIKE '%elle%';
select * from irc_entries where message ILIKE '%elle%';
select * from irc_entries where message ILIKE '%lennu%';
select count(*) from irc_entries where message ILIKE '%lennu%';
select count(*) from irc_entries where message ILIKE '%tumu%';
select count(*) from irc_entries where message ILIKE '%pornobaari%';
select count(*) from irc_entries where message ILIKE '%ismo%';
select count(*) from irc_entries where message ILIKE '%glubi%';
select count(*) from irc_entries where message ILIKE '%clubi%';
select count(*) from irc_entries where message ILIKE '%GC%';
\d irc_entries
select sender,count(*) from irc_entries group by sender;