Question

假如我的MYSQl里有A，B，C，D,E多个表，他们都有一个title,content的字段

假如我的MYSQl里有A，B，C，D,E多个表，他们都有一个title,content的字段，目前我是想要假如我的关键词是“你好吗”，然后从这些表里搜出来title,content里有代你好吗的记录，怎么查询呢

Answer 1

select a.title,b.title,c.title,d.title from a,b,c,d,e where a.title= '你好吗' and b.title= '你好吗' and c.title= '你好吗' and d.title = '你好吗'

Answer 2

select a.title,a.content,b.title,b.content,c.title,c.content,d.title,d.content from a,b,c,d,e where a.title like '%你好吗%' or a.content like '%你好吗%' or b.title like '%你好吗%' or b.content like '%你好吗%' or c.title like '%你好吗%' or c.content like '%你好吗%' or d.title like '%你好吗%' or d.content like '%你好吗%'

Answer 3

select title,content from a,b,c,d,e where title = "你好吗";