MySQL联接查询使用喜欢吗? [英] MySQL join query using like?

问题描述

我已经尝试使它工作了一段时间了，但是它似乎不起作用，也许甚至没有可能，我想做的就是使用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联接查询使用喜欢吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！