What does this SQL query statement mean? Solution

What does this SQL query statement mean? I am reading the code today! The system is dizzy !! Please check it out! $ SQL = & quot; SELECT & nbsp; lid, & nbsp; title, & nbsp; htmlfile, & nbsp; add_time & nbsp; FROM & nbs what does this SQL query statement mean?
I am reading the code today! The system is dizzy !! Please check it out!
$ 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 ";

In particular: (keyword LIKE '% ". preg_replace ("/(, |,)/", "% 'OR keyword LIKE' %", stripslashes ($ keyword )). "% ')

------ Solution --------------------
For example, $ keyword = "a, B ";
Preg_replace ("/(, |,)/", "% 'OR keyword LIKE' %", stripslashes ($ keyword ));
Replace the comma in the $ keyword string with the string % 'OR keyword LIKE' %
So
"(Keyword LIKE '% ". preg_replace ("/(, |,)/", "% 'OR keyword LIKE' %", stripslashes ($ keyword )). "% ')"
It becomes
"(Keyword LIKE '% a %' OR keyword LIKE '% B % ')"