Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > mysql查询问题,like的反向使用?

mysql查询问题,like的反向使用?

WBOY
Release： 2016-06-23 14:12:08
Original
1067 people have browsed it

mysql like

有没有这样的语句

比如

$str = "你好,今天你吃饭了吗?包子还是油饼啊?包子里边还有点维生素比油饼好";

数据库表t1里存的是 
id name
1  维生素
2  吃饭
3  运动
4  娱乐

用什么语句能匹配到用$str从t1中取到 维生素 和 吃饭 ?

回复讨论(解决方案)

MYSQL 里有一个LOCATE 函数

select * from t1 where find_in_set(name,$str)


SELECT * FROM t1 WHERE $str  LIKE CONCAT('%',name,'%');

Related labels：
mysql查询问题 like的反向使用?
source：php.cn
Previous article：为什么 new mysqli 会出错？ Next article：大家好，用xampp安装的php环境安装项目后局域网访问不了
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
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
MySQL: "Select text from... as <variable here or subquery>" I have the following table with the following data: id text language 1 german text german ...
From 2024-04-06 19:25:54
0
2
529
Scatterplot points do not maintain values ​​when zooming in d3.js This is my first time using d3.js, so please bear with me. I implemented it as pure JavaSc...
From 2024-04-06 18:16:26
0
1
403
Node.js: Unable to store SQL query results in an array I'm trying to push the results of a SQL query to an array. However, it doesn't seem to wor...
From 2024-04-06 14:14:46
0
1
373
**Error type: Unable to iterate 'NoneType' object** I want to use ssh tunnel to access Mysql database. Unfortunately, the architecture of this...
From 2024-04-06 10:26:38
0
1
378
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