searching a database with partial keywords

[DigitalDesign]

Can anyone give me hints in the right direction as to how one codes a search function which will search a MySQL database, and match results to a partial keyword?

[planetsim]

http://phpbuilder.com/board/search.php?s=&action=showresults&searchid=725652&sortby=lastpost&sortorder=descending hope that helps.

[revez2002]

Instead of using a PHP function, why not use LIKE in your SQL statement.

EG. $sql = "SELECT * FROM TABLE NAME WHERE field_name LIKE '%field_name%'";

[DigitalDesign]

Thanks for the help!