Is it a good idea to have a 'search table'?
For example, a search that can search 'users', 'groups' and 'pages' (Facebook style) would have fields like keywords, userid, groupid, and pageid.
That way the system can do a LIKE query on the keywords from one table.
Or would it be better like
keyword1, keyword2, keyword3, keyword4, keyword5, userid, groupid, pageid
keeping the keywords in each of the tables (user, group and page)… But I am quite sure I will not need the keywords for anything else than searching.