search question

I have a small database,
now I want to write a small seacrh for it ,
I don't have problem with single field search
but when I want to search all fields , what is the best way
to do it ,
I know this command
"SELECT * from table where field1 like 'string' or field2 like 'string.....
but with this command how i can find which field
contain my search string.
and nother question, how i can show a string search results
with different color or mode, for example bold or highlight it.
like yahoo and many other search engine

thank you, please don't think that i want complete source
I need some tips or guide ...