[PHP/Mysql] Wildcard searching.
Hey, this is another thing i need for the southpark script i made.
Code:
SELECT * FROM spdb WHERE epn ='" . $_GET['searchstring'] . "' ORDER BY epd ASC
Epn: Episode name
Epd: Episode number
well, this will let the user search for the Exact episode. but i want more like wildcard searching, anyone know? :laugh:
Re: [PHP/Mysql] Wildcard searching.
PHP Code:
SELECT * FROM spdb WHERE epn LIKE '%" . $_GET['searchstring'] . "%' ORDER BY epd ASC
Re: [PHP/Mysql] Wildcard searching.
a huge thanks superfun :)