Well, basically, I want to let my users search through "row1", "row2" and "row3" by only using one form field. My code currently looks like this (it's in PHP):

... AND `row1` LIKE \'' . $search_text . '\',
`row2` LIKE \'' . $search_text . '\',
`row3` LIKE \'' . $search_text . '\',
`row4` LIKE \'' . $search_text . '\''

However, that doesn't work. There are some other fields that are submitted, so that's why there's an "AND" at the beginning. I don't post the other parts since I know they work properly.

But how can I search through multiple rows, and show the database entry if it finds $search_text in at least one of the fields?

You want to be using an AND/OR between each row's like statement.

... AND `row1` LIKE \'' . $search_text . '\',
OR `row2` LIKE \'' . $search_text . '\',
OR `row3` LIKE \'' . $search_text . '\',
OR `row4` LIKE \'' . $search_text . '\''

Thanks alot! It works now.

But if someone enter "word1%word2", to search the first row1 and find word1, and then find word2 in row3 or row2? (Basically, one word is in one row, another word is in another row. Both words are from the same form field.)

If I understand you correctly in that case you will simply be returned more than one result. Your results will be in an array.

get a search script that is already made.. much easier