本文介绍了MySQL联接查询使用喜欢吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我已经尝试使它工作了一段时间了,但是它似乎不起作用,也许甚至没有可能,我想做的就是使用like执行MySQL连接查询,例如我发现的这个例子...

I have been trying to get this working for quite a while now but it just doesn't seem to work, maybe it is is not even possible, what i am wanting to do is to perform a MySQL join query using like, such as this example i found...

SELECT *
FROM Table1
INNER JOIN Table2 ON Table1.col LIKE '%' + Table2.col + '%'

但是它似乎根本不起作用,可以提供的任何帮助将是非常棒的,谢谢!

but it just doesn't seem to work at all, any help that can be given would be brilliant, thanks !

推荐答案

尝试

SELECT *
FROM Table1
INNER JOIN Table2 ON Table1.col LIKE CONCAT('%', Table2.col, '%')

MySQL进行字符串连接的方式与其他数据库不同,因此,如果要移植应用程序,则需要有一个替代版本,其中||用作连接运算符,正如迈克尔在另一个答案中提到的那样.不过,此运算符在MySQL中不起作用,因为它表示or.

MySQL does string concatenation differently from other databases, so in case you want to port your app, you need to have an alternate version where || is used as concatenation operator, as mentioned by Michael in another answer. This operator doesn't work in MySQL though, since it means or.

这篇关于MySQL联接查询使用喜欢吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-10 22:09