Учим быстрый поиск распознавать все введенные символы v1.1 fixed

if( $query == "" ) die();

$buffer = "";

function translit_en($string) {
  $letter = array(
		'io' => 'ё',		'q' => 'й',		'w' => 'ц',		'e' => 'у',		'r' => 'к',		't' => 'е',		'y' => 'н',		'u' => 'г',		
		'i' => 'ш',		'o' => 'щ',		'p' => 'з',		'[' => 'х',		']' => 'ъ',		'a' => 'ф',		's' => 'ы',		'd' => 'в',		
		'f' => 'а',		'g' => 'п',		'h' => 'р',		'j' => 'о',		'k' => 'л',		'l' => 'д',		';' => 'ж',		''' => 'э',		
		'z' => 'я',		'x' => 'ч',		'c' => 'с',		'v' => 'м',		'b' => 'и',		'n' => 'т',		'm' => 'ь',		',' => 'б',		
		'.' => 'ю',

		'~' => 'Ё',		'Q' => 'Й',		'W' => 'Ц',		'E' => 'У',		'R' => 'К',		'T' => 'Е',		'Y' => 'Н',		'U' => 'Г',		
		'I' => 'Ш',		'O' => 'Щ',		'P' => 'З',		'{' => 'Х',		'}' => 'Ъ',		'A' => 'Ф',		'S' => 'Ы',		'D' => 'В',		
		'F' => 'А',		'G' => 'П',		'H' => 'Р',		'J' => 'О',		'K' => 'Л',		'L' => 'Д',		':' => 'Ж',		'"' => 'Э',		
		'Z' => 'Я',		'X' => 'Ч',		'C' => 'С',		'V' => 'М',		'B' => 'И',		'N' => 'Т',		'M' => 'Ь',		'<' => 'Б',		
		'>' => 'Ю'
  );
  return strtr($string, $letter);
}

function translit_ru($string) {
  $letter = array(
		'ё' => '',		'й' => 'q',		'ц' => 'w',		'у' => 'e',		'к' => 'r',		'е' => 't',		'н' => 'y',		'г' => 'u',		
		'ш' => 'i',		'щ' => 'o',		'з' => 'p',		'х' => '[',		'ъ' => ']',		'ф' => 'a',		'ы' => 's',		'в' => 'd',		
		'а' => 'f',		'п' => 'g',		'р' => 'h',		'о' => 'j',		'л' => 'k',		'д' => 'l',		'ж' => ';',		'э' => '&#039;',		
		'я' => 'z',		'ч' => 'x',		'с' => 'c',		'м' => 'v',		'и' => 'b',		'т' => 'n',		'ь' => 'm',		'б' => ',',		
		'.' => 'ю',		

		'Ё' => '~',		'Й' => 'Q',		'Ц' => 'W',		'У' => 'E',		'К' => 'R',		'Е' => 'T',		'Н' => 'Y',		'Г' => 'U',		
		'Ш' => 'I',		'Щ' => 'O',		'З' => 'P',		'Х' => '{',		'Ъ' => '}',		'Ф' => 'A',		'Ы' => 'S',		'В' => 'D',		
		'А' => 'F',		'П' => 'G',		'Р' => 'H',		'О' => 'J',		'Л' => 'K',		'Д' => 'L',		'Ж' => ':',		'Э' => '&quot;',		
		'Я' => 'Z',		'Ч' => 'X',		'С' => 'C',		'М' => 'V',		'И' => 'B',		'Т' => 'N',		'Ь' => 'M',		'Б' => '<',		
		'>' => 'Ю'
  );
  return strtr($string, $letter);
}

$db->query("SELECT id, short_story, title, date, alt_name, category FROM " . PREFIX . "_post WHERE " . PREFIX . "_post.approve=1" . $this_date . " AND (short_story LIKE '%{$query}%' OR full_story LIKE '%{$query}%' OR xfields LIKE '%{$query}%' OR title LIKE '%{$query}%') ORDER by date DESC LIMIT 5");

 Варианты поиска

$en = translit_en($query);
$ru = translit_ru($query);

$db->query( "SELECT id, short_story, title, date, alt_name, category FROM " . PREFIX . "_post WHERE " . PREFIX . "_post.approve=1" . $this_date . " AND (title LIKE '%{$query}%' OR title LIKE '%{$en}%' OR title LIKE '%{$ru}%') ORDER by date DESC LIMIT 5" );

$en = translit_en($query);
$ru = translit_ru($query);

$db->query("SELECT id, short_story, title, date, alt_name, category FROM " . PREFIX . "_post WHERE " . PREFIX . "_post.approve=1" . $this_date . " AND (short_story LIKE '%{$query}%' OR title LIKE '%{$query}%' OR short_story LIKE '%{$en}%' OR title LIKE '%{$en}%' OR short_story LIKE '%{$ru}%' OR title LIKE '%{$ru}%') ORDER by date DESC LIMIT 5");

$en = translit_en($query);
$ru = translit_ru($query);

$db->query( "SELECT id, short_story, title, date, alt_name, category FROM " . PREFIX . "_post WHERE " . PREFIX . "_post.approve=1" . $this_date . " AND (short_story LIKE '%{$query}%' OR full_story LIKE '%{$query}%' OR title LIKE '%{$query}%' OR short_story LIKE '%{$en}%' OR full_story LIKE '%{$en}%' OR title LIKE '%{$en}%' OR short_story LIKE '%{$ru}%' OR full_story LIKE '%{$ru}%' OR title LIKE '%{$ru}%') ORDER by date DESC LIMIT 5" );