在我正在使用的表中,full_name列的格式为"名字姓氏">
例如。"约翰·韦斯特">
我正在使用这个:
$q="John";
$sql = "SELECT full_name FROM wp_users where full_name like '$q%' order by display_name ASC";
这工作正常,"约翰·韦斯特"被返回。
但是,如果我$q等于"西方"并尝试按姓氏搜索,则不会返回任何内容。是否有一个 mysql 语句可以用来更好地做到这一点?
尝试使用适合您的条件的野生字符连接
$sql = "SELECT full_name
FROM wp_users where full_name like concat('%', $q,'%')
ORDER BY display_name ASC";
或
$q = '%John%';
$sql = "SELECT full_name
FROM wp_users where full_name like '$q'
ORDER BY display_name ASC";
把百分比放在两边
$q="John";
$sql = "SELECT full_name FROM wp_users where full_name like '%$q%' order by display_name ASC";
你试过吗
$q="John";
$sql = "SELECT full_name FROM wp_users where full_name like '$q%' or full_name like '$%q' order by display_name ASC";