[PHP] Select all that contains in MySql

[Mike Tuller]

I have built a search function that searches a table for all items that 
match what you enter into the search field. I would like it to return 
all items that contain a certain string rather that matches. For 
example, I want to have it so that if I enter M in the search field, it 
will return all items that start with M.

Here is what I have so far.

$query = "SELECT * FROM software_assets WHERE $searchType LIKE 
'$search' ";

Thanks,
Mike
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php