运营商的问题，如 [英] Issue with the operator like

问题描述

我有这个表格，我用它来搜索数据库中的特定记录.

I have this form which i use it to search specific records from the database.

这是查询:

$sql = "select * from `hostess` where first_name_en like '%$term' or family_name_en like '%$term%' order by `family_name_en` asc";

问题是，如果我搜索 ie ele 会出现所有包含 ele 的名称，例如 elena 等，但是如果我写elena什么都不会出现.

The issue is that if i search i.e ele there come all the names which contain ele, such as elena, etc etc, but if i write elena nothing comes up.

怎么会?

推荐答案

是否有理由不使用 first_name_en 值末尾的 %?

Is there a reason why you didn't use the % at the end of the first_name_en value ?

$sql = "select * from `hostess` where first_name_en like '%$term%' or family_name_en like '%$term%' order by `family_name_en` asc"; 

对于大小写问题:

$term = strtolower($term);
$sql = "select * from `hostess` where lower(first_name_en) like '%$term%' or lower(family_name_en) like '%$term%' order by `family_name_en` asc"; 

这篇关于运营商的问题，如的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！