• <tfoot id='ZfEld'></tfoot>

  • <small id='ZfEld'></small><noframes id='ZfEld'>

    <i id='ZfEld'><tr id='ZfEld'><dt id='ZfEld'><q id='ZfEld'><span id='ZfEld'><b id='ZfEld'><form id='ZfEld'><ins id='ZfEld'></ins><ul id='ZfEld'></ul><sub id='ZfEld'></sub></form><legend id='ZfEld'></legend><bdo id='ZfEld'><pre id='ZfEld'><center id='ZfEld'></center></pre></bdo></b><th id='ZfEld'></th></span></q></dt></tr></i><div id='ZfEld'><tfoot id='ZfEld'></tfoot><dl id='ZfEld'><fieldset id='ZfEld'></fieldset></dl></div>
      <bdo id='ZfEld'></bdo><ul id='ZfEld'></ul>

        <legend id='ZfEld'><style id='ZfEld'><dir id='ZfEld'><q id='ZfEld'></q></dir></style></legend>

        像 MySQL 中区分大小写

        时间:2023-05-31

      1. <i id='y0I7g'><tr id='y0I7g'><dt id='y0I7g'><q id='y0I7g'><span id='y0I7g'><b id='y0I7g'><form id='y0I7g'><ins id='y0I7g'></ins><ul id='y0I7g'></ul><sub id='y0I7g'></sub></form><legend id='y0I7g'></legend><bdo id='y0I7g'><pre id='y0I7g'><center id='y0I7g'></center></pre></bdo></b><th id='y0I7g'></th></span></q></dt></tr></i><div id='y0I7g'><tfoot id='y0I7g'></tfoot><dl id='y0I7g'><fieldset id='y0I7g'></fieldset></dl></div>

            <small id='y0I7g'></small><noframes id='y0I7g'>

            <legend id='y0I7g'><style id='y0I7g'><dir id='y0I7g'><q id='y0I7g'></q></dir></style></legend>

              <bdo id='y0I7g'></bdo><ul id='y0I7g'></ul>
                <tbody id='y0I7g'></tbody>
            • <tfoot id='y0I7g'></tfoot>

                  本文介绍了像 MySQL 中区分大小写的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我有一个 MySQL 查询:

                  I have a MySQL query:

                  SELECT concat_ws(title,description) as concatenated HAVING concatenated LIKE '%SearchTerm%';
                  

                  我的表使用 MyISAM 编码为 utf8_general_ci.

                  And my table is encoded utf8_general_ci with MyISAM.

                  搜索似乎区分大小写.

                  我不知道如何修复它.出了什么问题和/或我该如何解决?

                  I can't figure out how to fix it. What's going wrong and/or how do I fix it?

                  推荐答案

                  试试这个:

                  SELECT LOWER(CONCAT_WS(title,description)) AS concatenated 
                  WHERE concatenated LIKE '%searchterm%'
                  

                  或(让你看出区别)

                  SELECT LOWER(CONCAT_WS(title,description)) AS concatenated 
                  WHERE concatenated LIKE LOWER('%SearchTerm%')
                  

                  这篇关于像 MySQL 中区分大小写的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:Mysql 在给定的日期时间范围内插入随机日期时间 下一篇:在 MySQL SELECT 查询中使用 IF 语句

                  相关文章

                  <legend id='nYtjD'><style id='nYtjD'><dir id='nYtjD'><q id='nYtjD'></q></dir></style></legend>

                    <small id='nYtjD'></small><noframes id='nYtjD'>

                  1. <i id='nYtjD'><tr id='nYtjD'><dt id='nYtjD'><q id='nYtjD'><span id='nYtjD'><b id='nYtjD'><form id='nYtjD'><ins id='nYtjD'></ins><ul id='nYtjD'></ul><sub id='nYtjD'></sub></form><legend id='nYtjD'></legend><bdo id='nYtjD'><pre id='nYtjD'><center id='nYtjD'></center></pre></bdo></b><th id='nYtjD'></th></span></q></dt></tr></i><div id='nYtjD'><tfoot id='nYtjD'></tfoot><dl id='nYtjD'><fieldset id='nYtjD'></fieldset></dl></div>
                    1. <tfoot id='nYtjD'></tfoot>

                        <bdo id='nYtjD'></bdo><ul id='nYtjD'></ul>