MySQL模糊查询多表查询

模糊查询

WHERE CONCAT(art_forum.Title,art_forum.Content) LIKE '%测试%'
//模糊查询Title和Content两个字段 CONCAT是将两个字段内容拼接起来

MySQL视图查询（视图多表查询）

SELECT
	`art_homepagearticle`.`id` AS `id`,
	`art_homepagearticle`.`Title` AS `Title`,
	`art_homepagearticle`.`Content` AS `Content`,
	`art_homepagearticle`.`UserId` AS `UserId`,
	`art_homepagearticle`.`ContentImageSrc` AS `ContentImageSrc`,
	`art_homepagearticle`.`ListImageSrc` AS `ListImageSrc`,
	`art_homepagearticle`.`ReleaseTime` AS `ReleaseTime`,
	`art_homepagearticle`.`BrowseNum` AS `BrowseNum`,
	( SELECT count( 0 ) FROM `art_homepagearticleclick` WHERE ( `art_homepagearticle`.`id` = `art_homepagearticleclick`.`HomePageArtId` ) ) AS `IllumineNum`,
	(
SELECT
	count( 0 ) 
FROM
	`art_homepagearticleclick` 
WHERE
	( ( `art_homepagearticleclick`.`UserId` = 2 ) AND ( `art_homepagearticleclick`.`HomePageArtId` = `art_homepagearticle`.`id` ) ) 
	) AS `HomePageArtclick`,
	`art_user`.`UserName` AS `UserName`,
	`art_user`.`HeadImg` AS `HeadImg` 
FROM
	( `art_user` JOIN `art_homepagearticle` ON ( ( `art_homepagearticle`.`UserId` = `art_user`.`id` ) ) ) 
WHERE
	( `art_homepagearticle`.`id` = 4 )



SELECT
  `art_newscomment`.`id` AS `id`,
  `art_newscomment`.`NewsId` AS `NewsId`,
  `art_newscomment`.`UserId` AS `UserId`,
  `art_newscomment`.`CommentContent` AS `CommentContent`,
  `art_newscomment`.`CommentTime` AS `CommentTime`,
  `art_newscomment`.`IllumineNum` AS `IllumineNum`,
  `art_user`.`UserName` AS `UserName`,
  `art_user`.`HeadImg` AS `HeadImg` 
FROM
  (
  ( `art_newscomment` JOIN `art_news` ON ( ( `art_newscomment`.`NewsId` = `art_news`.`id` ) ) )
  JOIN `art_user` ON ( ( `art_newscomment`.`UserId` = `art_user`.`id` ) ) 
  )