這條SQL查詢語句什麼意思啊解決辦法

這條SQL查詢語句什麼意思啊
今天在看代碼!看到這裡暈了!!請大蝦們看看!
$sql= "SELECT lid, title, htmlfile, add_time FROM zixun_list WHERE tid= '$tid ' AND lid <> '$lid ' AND (keyword LIKE '% ".preg_replace( "/(,|，)/ ", "% ' OR keyword LIKE '% ", stripslashes($keyword)). "% ') ORDER BY lid DESC LIMIT 2 ";

特別是這個:(keyword LIKE '% ".preg_replace( "/(,|，)/ ", "% ' OR keyword LIKE '% ", stripslashes($keyword)). "% ')

------解決方案--------------------
比如$keyword = "a,b ";
preg_replace( "/(,|，)/ ", "% ' OR keyword LIKE '% ", stripslashes($keyword));
就是把$keyword字串中的逗號替換為字串 % ' OR keyword LIKE '%
那麼
"(keyword LIKE '% ".preg_replace( "/(,|，)/ ", "% ' OR keyword LIKE '% ", stripslashes($keyword)). "% ') "
就變成
"(keyword LIKE '%a% ' OR keyword LIKE '%b% ') "啦

