blocks|key|4522389|text|如果我是对的，这样的东西对你来说应该是有效的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4522390|SELECT+*+FROM+table1+AND+table2+WHERE+table1code+LIKE+'%25e%25'|code-block|syntax|javascript|4522391|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If I'm right, something like this should work for you:

<pre><code>SELECT * FROM table1 AND table2 WHERE table1code LIKE '%e%'
</code></pre>

blocks|key|5005103|text|SELECT+t1.name,+t2.name+FROM+
Table1+t1+INNER+JOIN+Table2+t2+ON+(t1.name+=+t2.code)
WHERE+t1.code+LIKE+'%25b%25'+OR+t1.code+LIKE+'%25e%25'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|5005104|由于这是一个内连接，因此如果第二个表中有匹配的代码，则只会返回第一个表中的行。如果希望显示Table1中任何匹配的行，请使用LEFT+JOIN|unstyled|5005105|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>SELECT t1.name, t2.name FROM 
Table1 t1 INNER JOIN Table2 t2 ON (t1.name = t2.code)
WHERE t1.code LIKE '%b%' OR t1.code LIKE '%e%'
</code></pre>

Since this is an inner join this will only return rows from the first table if there is a matching code in the second. If you would want to display any matching rows from Table1 use LEFT JOIN

blocks|key|4522440|text|为了使用连接2个表，如函数或实例，函数将|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4522441|使用"like"|4522442|+**column_name1+like+'%25'column_name2'%25'**|code-block|syntax|javascript|4522443|使用"instr"|4522444|+**instr(column_name1,column_name2)>0**|4522445|其中，column_name1引用列，column_name2引用您正在搜索的模式|4522446|在您的示例中，尝试如下所示|4522447|使用like的|4522448|SELECT+Table1_name,+Table2_name+FROM+
(+SELECT+Table1.name+table1_name
++++++++,Table1.code+table1_code
++++++++,Table2.name+table2_name
++++++++,Table2.code+table2_code
FROM+Table1+JOIN+Table2+ON++
(Table2.name+LIKE+'%25'%7C%7CTable1.name%7C%7C'%25')+OR+(Table1.code+LIKE+'%25'%7C%7CTable2.code%7C%7C'%25')
WHERE+Table1.name=Table2.code
)++new1
+WHERE+Table1_code+LIKE+'%25b%25'+OR+Table1_code+LIKE+'%25e%25'|4522449|使用INSTR的|4522450|+SELECT+Table1_name,+Table2_name+FROM+
(+SELECT+Table1.name+table1_name
++++++++,Table1.code+table1_code
++++++++,Table2.name+table2_name
++++++++,Table2.code+table2_code
FROM+Table1+JOIN+Table2+ON
INSTR(Table2.name,Table1.name)>0+++OR+INSTR(Table1.code,Table2.code)>0+
WHERE+Table1.name=Table2.code
)++new1
+WHERE+Table1_code+LIKE+'%25b%25'+OR+Table1_code+LIKE+'%25e%25'|4522451|entityMap^0|4|7|E|3|0|2|6|0|0|2|7|0|0|3|F|J|M|0|0|0|0|0|7|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]|$9|17|A|18|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|1C|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1D|8|@$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|O|3|P|5|J|7|1G|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|1H|8|@$9|1I|A|1J|B|C]|$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|S|3|T|5|6|7|1M|8|@]|D|@]|E|$]]|$1|U|3|V|5|6|7|1N|8|@]|D|@]|E|$]]|$1|W|3|X|5|J|7|1O|8|@]|D|@]|E|$K|L]]|$1|Y|3|Z|5|6|7|1P|8|@$9|1Q|A|1R|B|C]]|D|@]|E|$]]|$1|10|3|11|5|J|7|1S|8|@]|D|@]|E|$K|L]]|$1|12|3|-4|5|6|7|1T|8|@]|D|@]|E|$]]]|13|$]]

Inorder to join 2 table using like function or instr function will 

Using "like"

<pre><code> **column_name1 like '%'column_name2'%'**
</code></pre>

Using "instr"

<pre><code> **instr(column_name1,column_name2)&gt;0**
</code></pre>

where column_name1 is referencing column and column_name2 is pattern you are searching 

in your example try this 

Using like

<pre><code>SELECT Table1_name, Table2_name FROM 
( SELECT Table1.name table1_name
 ,Table1.code table1_code
 ,Table2.name table2_name
 ,Table2.code table2_code
FROM Table1 JOIN Table2 ON 
(Table2.name LIKE '%'||Table1.name||'%') OR (Table1.code LIKE '%'||Table2.code||'%')
WHERE Table1.name=Table2.code
) new1
 WHERE Table1_code LIKE '%b%' OR Table1_code LIKE '%e%'
</code></pre>

Using INSTR

<pre><code> SELECT Table1_name, Table2_name FROM 
( SELECT Table1.name table1_name
 ,Table1.code table1_code
 ,Table2.name table2_name
 ,Table2.code table2_code
FROM Table1 JOIN Table2 ON
INSTR(Table2.name,Table1.name)&gt;0 OR INSTR(Table1.code,Table2.code)&gt;0 
WHERE Table1.name=Table2.code
) new1
 WHERE Table1_code LIKE '%b%' OR Table1_code LIKE '%e%'
</code></pre>

I had search for the solution but so far i didn't find it yet.

So here the problem, let say i have 2 table:

Table1

<pre><code>name | code
-------------------
a | [a][b][c]
b | [a][c][d]
c | [a][e]
</code></pre>

Table2

<pre><code>code | name
-------------------
a | aaaa
b | bbbb
c | cccc
d | dddd
e | eeee
</code></pre>

I want to do multiple select <code>Table1.name</code> and <code>Table2.name</code> where <code>Table1.code LIKE '%b%'</code> OR <code>Table1.code LIKE '%e%'</code>

so it should be result like this:

<pre><code>name | name
------------------
a | aaaa
c | cccc
</code></pre>

I did try :

<pre><code>SELECT Table1.name, Table2.name 
FROM Table1, Table2 
WHERE Table1.code LIKE '%b%' OR Table1.code LIKE '%e%'
</code></pre>

But it didn't work. I'm newbie on this, any help deeply appreciated :)

MySQL Multiple LIKE between multiple table

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

问多个表之间的MySQL多个LIKE
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问多个表之间的MySQL多个LIKEEN