Please can someone tell me how to make the following into a 'begins with' search, so that "inter" in the input field will bring up 'interest', 'internet', and 'interview'? It needs to be for any string length.
I tried using LIKE, but it didn't like the percentage sign.
$query="SELECT * FROM contacts WHERE (company='$search_company') or
(classification='$search_classification') ORDER BY company ASC";