Such search will kill your database on 100k rows. If you want write article about simple search please read about FTS in PostgreSQL.