我有800多万条带有“名字”栏的记录,我必须找到优化搜索select * from ... like '%string%'的方法。[char][number of chars][char][number of chars][char][number of chars]...我们可以有这样的字符串:result='E01c01e02l01o02p01r03t01'
我正在尝试用PHP和MySQL创建一个基本的搜索引擎。mysql_connect($db_hostname, $db_username, $db_password);
if(isset($$query = "select * from backedupdata where descr like '%$search_value%'"
$column['db'].'` '.$column['db']."` LIKE ".$column['db']."` LIKE ".= @new PDO(
"mysql:host={$sql_details['host']};dbname={$sql_details['db']}",$column[