mysql 查询 - 包含？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3468812/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-08-31 16:50:09 来源:igfitidea点击:
mysql query - contains?
提问by JJunior
how can i search for a particular string in mysql? I tried using contains- gives me error:
如何在 mysql 中搜索特定字符串？我尝试使用 contains- 给我错误：
SELECT r.name
, r.network
, r.namestring
, i.name
, r.rid
, i.id
, d.dtime
, d.ifInOctets
, d.description
FROM router AS r
INNER JOIN interface AS i ON r.rid = i.rid
INNER JOIN 1278993600_1_60 AS d ON i.id = d.id
AND d.dtime BETWEEN 1279027200 AND 1279029000
WHERE r.network = "ITPN"
AND i.status = "active"
AND i.description CONTAINS ' DBK'
Please help.
请帮忙。
回答by RedFilter
Try
尝试
AND i.description LIKE '% DBK%'
回答by Sarfraz
Looking for LIKE:
寻找LIKE：
AND i.description LIKE '% DBK%'
More Info:
更多信息：
回答by Michael Pakhantsov
use like, i.e. AND i.description LIKE '%DBK%'
使用 like，即 AND i.description LIKE '%DBK%'
回答by FrustratedWithFormsDesigner
Try
尝试
...AND i.description like '% DBK%'
Or
或者
...AND upper(i.description) like '% DBK%'
If you want to get anything with DBK, DbK, dbk, dBk, ...
如果你想用DBK, DbK, dbk, dBk, ...
