Home > Database > Mysql Tutorial > mysql-sql 通配符小问题 在线急等

mysql-sql 通配符小问题 在线急等

WBOY
Release: 2016-06-06 09:44:34
Original
1217 people have browsed it

mysqlsql通配符数据库

本人mysql菜鸟一枚
遇到通配符的问题求助各位大神

我想选取users表中姓名包含"szo"或者"szö"的数据
所以写了以下代码:
select * from users where name like '%sz[oö]%'
数据库有这样的数据
但是返回值是0
尝试
select * from users where name like '%szo%' or name like '%szö%'
有结果
请问这两个有什么不一样?

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