也许是这样的（这里是SQL FIDDLE ）？
SELECt table1.title title1, table2.title title2FROM table1, table2WHERe table1.title LIKE CONCAt('%',table2.title,'%') OR table2.title LIKE CONCAt('%',table1.title,'%');
也许是这样的（这里是SQL FIDDLE ）？
SELECt table1.title title1, table2.title title2FROM table1, table2WHERe table1.title LIKE CONCAt('%',table2.title,'%') OR table2.title LIKE CONCAt('%',table1.title,'%');名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
