mysql中单个汉字精确查找有关问题,回帖

WBOY
Release: 2016-06-13 13:46:03
Original
957 people have browsed it

mysql中单个汉字精确查找问题,在线等回帖
为什么精确查找一个汉字的时候通常会有多个结果出来?结果并不是要查找的汉字,这个问题大家遇到过吗?怎么解决?

------解决方案--------------------
应该不会出现这种情况的!

PHP code


SELECT hanzi FROM `hanzi` WHERE hanzi = ‘秦'
<br><font color="#e78608">------解决方案--------------------</font><br>不会吧
<br><font color="#e78608">------解决方案--------------------</font><br>应该不会出现这样的情况的<br><br>这样子查询<br>
Copy after login
PHP code


SELECT hanzi FROM `hanzi` WHERE hanzi = ‘%秦%'
<br><font color="#e78608">------解决方案--------------------</font><br>对于聚合,试试下面的代码<br>set names 'gbk';<br>select hanzi from hanzi where hanzi like '%秦%'; <div class="clear">
                 
              
              
        
            </div>
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template