SELECT * FROM `таблица` WHERE `поле 1` LIKE 'значение%' OR `поле 2` LIKE 'значение%';

<?php
include './system/data/db.php';
$search = "Проверочная новость";
$connect = mysql_query("SELECT * FROM `date` WHERE `text` LIKE '%$search%' OR `title` LIKE '%$search%'");
$mysql = mysql_fetch_assoc($connect);
include './template/news.php';

?>

mysql_query(...) or die(mysql_error());

while($mysql = mysql_fetch_assoc($connect)){
..бла, бла, бла
}