创建一个完整的mysql搜索查询，搜索多个表

Question

I am trying to search my full website but I'm unsure how to make the query.

    $query = "SELECT * FROM 
game_content,
tech_content,
hint_content
 WHERE 
title LIKE '%".$input."%' 
description LIKE '%".$input."%'";

The tables i want to search are: game_content,tech_content,hint_content & the columns are: title,description each table has these columns

To be honest I'm confused using JOIN i have been getting lots of unexpected results.

Answer 1

After trying out some of your answers i decided to do what Dieter suggested in the comments.

    //set the queries.
$query[1] = "SELECT * FROM game_content WHERE title LIKE '%".$input."%' OR description LIKE '%".$input."%'";
$query[2] = "SELECT * FROM hint_content WHERE title LIKE '%".$input."%' OR description LIKE '%".$input."%'";
$query[3] = "SELECT * FROM tech_content WHERE title LIKE '%".$input."%' OR description LIKE '%".$input."%'";

    //loop the queries setting the results
for ( $i = 1; $i <= 3; $i++ ) {

    $result[$i] = mysqli_query( $connection, $query[$i] );
    check_query( $result[$i] );

    while( $row = mysqli_fetch_assoc( $result[$i] ) ) {

        //display output
    }
}

It is only a small site so this will suffice.