Search All Categories

[trigger8]

I have the following tables in a database. How do I run a search in all the columns at once? I've no problem creating a search against a particular table, but how do I make a 'search all' function?

-----------
News
-----------
id
heading
Topic
Frequency
fk

-----------
Entertainment
-----------
id
heading
Topic
Frequency
fk

[freddydoesphp]

You should start by combining those two tables with an extera field for the type, News or Entertainment. Instead of storing the records in two different tables. Then you should have no problem at all searching all records. You see the whole point of a database is to make life easier, you have made life harder on yourself by making separate tables for this type of data storage.