Assuming autocomplete is required, the following result was found.
How? This has to be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID,...