Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

这种匹配是啥回事

WBOY
Release： 2016-06-23 13:34:45
Original
795 people have browsed it

在写php获取数据库信息的时候,看到别人这么写SELECT * FROM `sw_goods` WHERE ( goods_name like "诺%" )
其中的 like "诺%"
是匹配啥呢?
我的印象中两边都要有%,一边有的情况是咋回事呢


回复讨论(解决方案)

like "诺%"
表示以 诺 开头

like "%诺%"
表示含有 诺 

Related labels：
这种匹配是啥回事
source：php.cn
Previous article：PHP 数组中如果有一个元素相同，如何拼接其他元素 Next article：设计模式之PHP项目应用（23种设计模式目录）
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
Latest Articles by Author
Latest Issues
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
Problem: MySQL regular expression (limiter not working) Mod Note: Do Not Remove/Do Not Close I asked this question before and the admins closed it...
From 2024-04-02 23:35:21
0
1
263
How to select, match and return values ​​in mysql query? I have two tables, the transfer table and the clubs table. This is the table transfer: id ...
From 2024-04-02 17:18:57
0
1
380
How to stop Javascript code from automatically converting hsl to rgb I have this code where I assign a color to an object and then use a condition to check if ...
From 2024-03-31 16:46:02
0
1
338
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template