mysql 的 like 模糊查询问题 - V2EX

Home Sign Up Sign In

› MySQL 5.5 Community Server

› MySQL 5.6 Community Server

› Percona Configuration Wizard

› XtraBackup 搭建主从复制

Great Sites on MySQL

› MySQL Performance Blog

› Severalnines

推荐管理工具

推荐书目

› MySQL Cookbook

MySQL 相关项目

参考文档

› http://mysql-python.sourceforge.net/MySQLdb.html

This topic created in 4329 days ago, the information mentioned may be changed or developed.

$con['staff_departmentid']=array('like',"5");

需要模糊查询的数据是
5-6-7-8
5-7-10
6-10
5
6
——————————————————————————————————
为什么只有5能匹配。
“5-6-7-8
5-7-10”
这两个为什么不能匹配

9 replies • 2014-11-28 14:00:29 +08:00

1

a2z

Nov 27, 2014 via iPhone

'5%'

2

444683462

OP

Nov 27, 2014

@a2z 谢谢。太大意了

3

ell3n

Nov 27, 2014

囧

4

zts1993

Nov 27, 2014

难道是Tp？

5

xzem

Nov 27, 2014 via Android

thinkphp

6

Mac

Nov 27, 2014 via Android

楼主是手册型程序员，鉴定完毕，建议以后问此类问题首先百度，会有意想不到的结果

7

CupTools

Nov 27, 2014 via Android

%5%

9

zenliver

Nov 28, 2014

@CupTools infix query 等于扫表

About · Help · Advertise · Blog · API · FAQ · Privacy · Solana · 2243 Online Highest 6679 ·

Select Language

创意工作者们的社区

World is powered by solitude

VERSION: 3.9.8.5 · 32ms · UTC 04:58 · PVG 12:58 · LAX 21:58 · JFK 00:58
♥ Do have faith in what you're doing.