Home > Article > Backend Development > 这种婚配是啥回事
这种婚配是啥回事
- WBOYOriginal
- 2016-06-13 12:19:40910browse
这种匹配是啥回事
在写php获取数据库信息的时候,看到别人这么写SELECT * FROM `sw_goods` WHERE ( goods_name like "诺%" )
其中的like "诺%"
是匹配啥呢?
我的印象中两边都要有%,一边有的情况是咋回事呢
------解决思路----------------------
like "诺%"
表示以 诺 开头
like "%诺%"
表示含有 诺
Statement：
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
Previous article：对于社保截止日接口的学习记要-对于php时间的操作(date_time和timestamp)Next article：PHPExcel（二）- 导入功能