1、SELECT * FROM `pw_mutithreads` a LEFT JOIN pw_threads b ON a.tid = b.tid where b.subject like '%lmq%'
显示行 0 - 3 ( 4 总计, 查询花费 0.1842 秒)
2、SELECT * FROM pw_threads a where a.subject like '%lmq%'
1、SELECT * FROM `pw_mutithreads` a LEFT JOIN pw_threads b ON a.tid = b.tid where b.subject like '%lmq%'
显示行 0 - 3 ( 4 总计, 查询花费 0.1842 秒)
2、SELECT * FROM pw_threads a where a.subject like '%lmq%'