I have a site with 4 diffrent catagories.
Each catagory should be browsed and searched.
There for i created 4 tables with identical fields.
for time consuming on user search, rather have it on 4 tables then 1 big bloatable table that can hold many items.
for each catagory there is a field of number times it was viewed.
i want to know which SQL command i can do to those 4 tables with identical fields name to know which is the top 10 viewed from all of them.

2nd thing i like is to do a LIKE command to them all in a description field i have in all 4 table for wildcard search.

thank you!