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 执行字符串连接的方式与其他数据库不同，因此如果您想移植应用程序，您需要有一个替代版本，其中 || 用作连接运算符，正如 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.
相关文章