How can I search for a keyword through many tables (e.g., books, software, movies) in a MySQL databse using single query? All tables have the same fields (e.g., name, price, description). After successfully querying, how to identify as to which table the result came from? Thanks.
