$search = htmlspecialchars($_POST['search']);
$query = "SELECT * FROM table1 where (concat(gorodru, name, adres) like '%$search%') and (CURDATE()<dview) ORDER BY dsort";
$sql = mysql_query($query, $db);
if (mysql_num_rows($sql)>0) // Если кол-во записей не ноль
    { 
        while ($sqlrow=mysql_fetch_array($sql))
     {        

SELECT * FROM table1 where gorodru like 'мо'

SELECT * FROM `table1` WHERE gorodru='Москва' 

SELECT * FROM `table1` WHERE goroden=moskva

// Данные для mysql сервера
$dbhost = 'localhost'; // Хост
$dbuser = 'admin'; // Имя пользователя
$dbpassword = '123'; // Пароль
$dbname = 'listhotel'; // Имя базы данных
// Подключаемся к mysql серверу
$db = mysql_connect($dbhost, $dbuser, $dbpassword);
mysql_query("SET CHARACTER SET 'cp1251'");
// Выбираем нашу базу данных
mysql_select_db($dbname, $db);

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta http-equiv="Content-Language" content="ru">

Variable_name 	Value 
collation_connection	cp1250_general_ci
collation_database	cp1251_general_ci
collation_server	cp1251_general_ci

CREATE TABLE IF NOT EXISTS `hotels` (
  `idhotel` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(100) NOT NULL,
  `goroden` char(50) NOT NULL,
  `gorodru` char(50) NOT NULL,
  `adres` char(255) DEFAULT NULL,
  `tip` char(30) DEFAULT NULL,
  `files` char(20) DEFAULT NULL,
  `filesbig` char(20) DEFAULT NULL,
  `title` char(150) DEFAULT NULL,
  `description` char(255) DEFAULT NULL,
  `keywords` char(255) DEFAULT NULL,
  `vip` tinyint(1) DEFAULT NULL,
  `dadd` date DEFAULT NULL,
  `dview` date DEFAULT NULL,
  `dsort` date DEFAULT NULL,
  `contfio` char(150) DEFAULT NULL,
  `contemail` char(50) DEFAULT NULL,  
  PRIMARY KEY (`idhotel`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `hotels`
--

INSERT INTO `hotels` (`idhotel`, `name`, `goroden`, `gorodru`, `adres`, `tip`, `files`, 
`filesbig`, `title`, `description`, `keywords`, `vip`, `dadd`, `dview`, `dsort`, `contfio`, `contemail`) VALUES
(1, 'Гостиничный комплекс КОСМОС', 'moskva', 'Москва', 'Россия, г. Москва, ул. Проспект 
Мира, 150', 'Гостиница', '0000s.php', '0000.php', 'Гостиница КОСМОС', 'Гостиница КОСМОС', 
'Гостиница КОСМОС', NULL, '2011-04-14', '2011-04-30', '2011-04-30', 'Иванов Иван Иванович', 
'ivan@mail.ru'),
(2, 'Гостиница Альбатрос', 'sochi', 'Сочи', 'Сочи, п. Вардане, ул. Молодежная, 22', 
'Гостиница', '0001s.php', NULL, NULL, NULL, NULL, NULL, '2011-04-16', '2011-12-01', 
'2011-04-01', 'Демина Регина', 'demreg@mail.ru');

SELECT * FROM `table` WHERE `gorodru` LIKE '%Мо%'

CREATE TABLE IF NOT EXISTS `config` (
  `updatsum` date DEFAULT NULL,
  `allelementdb` smallint(5) unsigned DEFAULT NULL,
  `activelementdb` smallint(5) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `config`
--

INSERT INTO `config` (`updatsum`, `allelementdb`, `activelementdb`) VALUES
('2011-04-17', 2, 2);

Variable_name 	Value 
collation_connection	utf8_unicode_ci
collation_database	utf8_general_ci
collation_server	latin1_general_ci

// Подключаемся к mysql серверу
$db = mysql_connect($dbhost, $dbuser, $dbpassword);
mysql_query("SET CHARACTER SET 'utf8'");

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

$query = "SELECT * FROM hotels where (concat(gorodru, name, adres) like '%$search%') and (CURDATE()<dview) ORDER BY dsort";

SELECT * FROM hotels where gorodru like '%мо%'

SELECT * FROM hotels where gorodru like '%мо%

SELECT * FROM `table` WHERE `gorodru` LIKE '%Мо%

<?php header('Content-type: text/html; charset=utf-8')?>

mysql_query("set character_set_client='utf8'");
mysql_query("set character_set_results='utf8'");
mysql_query("set collation_connection='utf8_general_ci'"); 

mysql_query("set character_set_client='utf8'");
mysql_query("set character_set_results='utf8'");
mysql_query("set collation_connection='utf8_general_ci'");