<![CDATA[BIWEB开源PHP WMS系统创始人ArthurXF肖飞的blog]]> http://www.bizeway.net/index.php zh-cn http://www.bizeway.net/read.php? <![CDATA[MYSQL多表查询结果合并的办法]]> ArthurXF <arthurxf@gmail.com> Wed, 07 Sep 2011 07:27:43 +0000 http://www.bizeway.net/read.php? OR content LIKE ''%biweb%'' UNION SELECT * FROM biweb_user WHERE title LIKE
''%biweb%'' OR content LIKE ''%biweb%'' ORDER BY submit_date DESC";

使用UNION可以把多个select的结果集合并后，进行排序，可以轻松实现多表查询结果合并。

ArthurXF倾情奉献！ ]]> http://www.bizeway.net/read.php?&guid=0#topreply <![CDATA[[评论] MYSQL多表查询结果合并的办法]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://www.bizeway.net/read.php?&guid=0#topreply