Answer 1

SELECT column1, column2, column3, column4
FROM yourtable
WHERE (
column1 = keyword OR
column2 = keyword OR
column3 = keyword OR
column4 = keyword)

Not sure how large your table is but I can't think of an easier solution offhand. If you have many columns you should be able to narrow them down to a few that would contain the value you're looking for.