MySQL 全文搜索多个字段

Question

我有一些像这样的表:

car/model
Audi A2 2.0 TDI
Audi A8 2.5 TDI
Audi A6 4.2 V8

我从 PHP 得到这个变量:'Audi A8'

当我运行这个查询时:

select * from cars where match(car, model) against ('Audi A8') 

MySQL 返回:

Audi A2 2.0 TDI
Audi A8 2.5 TDI
Audi A6 4.2 V8

我只想要“奥迪 A8 2.5 TDI”。我该怎么做？

Answer 1

将值拆分为名字和姓氏:

$names = explode( ' ', $value );
$firstname = mysql_real_escape_string( $names[ 0 ] );
$lastname = mysql_real_escape_string( $names[ 1 ] );

并运行查询:

mysql_query( "SELECT * FROM people WHERE Firstname = '$firstname' AND Lastname = '$lastname'" );