mysql - SQL 与列名连接

Question

我想要执行这样的 SQL 请求:

SELECT p.ID, p.post_title
FROM ".$wpdb->prefix."posts AS p
INNER JOIN ".$wpdb->prefix."postmeta pm
ON pm.post_id=p.ID AND pm.meta_key='shops_list'
INNER JOIN ".$wpdb->prefix."follow AS f
ON pm.meta_value LIKE CONCAT('%',f.shop_followed_id,'%')

shop_followed_id 是列名，它不起作用，但是当我使用 CONCAT('%',163,'%') 进行测试时，它起作用了。

你知道语法错误在哪里吗？

meta_value 示例:a:3:{i:0;s:3:"168";i:1;s:2:"22";i:2;s:2:"43";}shop_followed_id 示例:168

Answer 1

在我看来你好像倒退了。尝试:

INNER JOIN ".$wpdb->prefix."follow AS f
ON f.shop_followed_id LIKE CONCAT('%',pm.meta_value,'%')