The simpler the PHP search function, the better. how can I solve this problem?

PHP search function. the simpler the better. please be careful. I would like to ask how PHP performs the search function. the simpler the better. I wrote this myself: Page 1: & lt; formaction = & quot; search. php & quot; method = & quot; POST & quot; name = & quot; form1 & quot; about the PHP search function. the simpler the better. please
As the question. I would like to ask, how does PHP do the search function? the simpler the better.
I wrote this myself:
Page 1:

---------------------------------------------
Search. php page:

$ Search =$ _ POST ['search'];
$ SQL = mysql_query ("SELECT * FROM job WHERE address like '$ search '");
$ Search1 = mysql_fetch_array ('$ SQL ');
Echo $ search1;
?>

--------------------------------------------
Please kindly advise.
Are two pages bound to the same data table?

------ Solution --------------------
$ SQL = mysql_query ("SELECT * FROM job WHERE address like '% $ search % '");
$ Search1 = mysql_fetch_array ($ SQL );

------ Solution --------------------
Row