MySQL连接查询使用like? [英] MySQL join query using 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 执行字符串连接的方式与其他数据库不同，因此如果您想移植应用程序，您需要有一个替代版本，其中 || 用作连接运算符，正如 Michael 在另一个答案.但是这个运算符在 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连接查询使用like?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！