MySQL encounters a classic example--(written when encountered)

1, the general search will only search the title, there are special circumstances, is the title and content search together!

1 --Fuzzy search is just a search title2$sql="Select Count(*) as sum  fromPublishwherePub_title like '%{$keyword}%' orPub_content like '%{$keyword}%'";3 4 --Fuzzy Search search title and content5$sql="Select *  fromPublish Left Join User  onPub_owner= user_name wherePub_title like '%{$keyword}%' orPub_content like '%{$keyword}%' Order  byPub_timedescLimit $offset, $rowsPerPage ";

MySQL encounters a classic example--(written when encountered)