Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php联表取值问题

php联表取值问题

WBOY
Release： 2016-06-23 14:00:43
Original
960 people have browsed it

表1                                                               表2

id                                                                   id              txt

#1,#2,                                                            1              标签1

                                                                        2              标签2 



SELECT * FROM 表1 LEFT JOIN 表2 ON 表1.id=表2.id
Copy after login


不知道各位明白我的意思没， 就是 表1 id 的 #1,值 #和,之间的数字 对应表2的id数字 然后取得表2的txt值。这样的需求该怎么做呢？


回复讨论(解决方案)

SELECT * FROM 表1 LEFT JOIN 表2 ON 表2.id in (REPLACE(表1.id, '#', ''))
Copy after login
Copy after login

SELECT * FROM 表1 LEFT JOIN 表2 ON 表2.id in (REPLACE(表1.id, '#', ''))
Copy after login
Copy after login



我只想说：  你叼！      头像是个多么甜美的妹子啊。

Related labels：
php联表取值问题
source：php.cn
Previous article：新手求教for怎么打印循环0.01这样小数点格式的数字。 Next article：关于递归算法的讨论
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
How to insert multiple rows in MySQL table and return new IDs? Normally I can insert a row in a MySQL table and get the last_insert_id. But now, I want t...
From 2024-04-06 10:03:44
0
2
294
How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
From 2024-04-04 18:17:27
0
1
3567
Efficient way to fill missing values ​​in unordered map from SQL table (SQL/C++) Question Currently there is a system that reads unique identifiers (ids) and their attache...
From 2024-04-04 11:47:44
0
1
345
How to pass multiple lists from ajax to Django I have a problem, I want to get all the data from the list, so I want to loop through each...
From 2024-04-03 23:20:06
0
1
362
Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
From 2024-04-03 14:46:04
0
1
298
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