I'm working on a site, and have 3 tables (articles, news, and blogs) that I would like to search in one query. Each table has at least 2 columns I would like to search. (title and post)

The script below works for a query on a single table but I want to know if there is a way to modify it to work on all three tables at once...

<?php

if(isset($_GET['keyword'])){
$keyword = trim($_GET['keyword']) ;
$keyword = mysqli_real_escape_string($db, $keyword);



$query = "select title,article_post from articles where title like '%$keyword%' or article_post like '%$keyword%'";

//echo $query;
$result = mysqli_query($db,$query);
if($result){
if(mysqli_affected_rows($db)!=0){
while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)){
echo '<p> <h1 class="tite"><a href="#">'.$row['title'].'</a> </h1><br> '.$row['article_post'].'</p><br>' ;
}
}else {
echo 'Could not find"'.$_GET['keyword'].'"';
}

}
}else {
echo "";
}
?>