soundex可以在mysql的列中使用吗？(can soundex be used on portion of a column in mysql?)

 是否可以使用soundex比较列的一部分与搜索词？ 例如，如果用户搜索“fivethreeree” - 它会发现“金色金属Nirve体育五十三巡洋舰”。 我试着将soundex与定位功能结合起来，但遇到了一个错误。 这是我的PHP代码： 
 
$soundex = soundex($keyword);
$soundexPrefix = substr($soundex, 0, 2); 
$sql = "SELECT name ".
"FROM products WHERE SOUNDEX(LOCATE('$keyword', name)) LIKE '%$soundexPrefix%'";

Is it possible to use soundex to compare portion of a column with search term? For example if a user searches "fiftythree" - it will find "Nirve Sports Fifty-Three Cruiser in Gold Metallic". I tried combining soundex with locate function but got an error. Here is my php code:
 
$soundex = soundex($keyword);
$soundexPrefix = substr($soundex, 0, 2); 
$sql = "SELECT name ".
"FROM products WHERE SOUNDEX(LOCATE('$keyword', name)) LIKE '%$soundexPrefix%'";

原文：https://stackoverflow.com/questions/9952959