Ok, this works fine for the "begins with" search- Thanks! However, I also plan on having a "ends with" feature and this wildcard will not work for this as it's searching domain names. So the MySQL database contains data like the following:
Originally Posted by PhilipToop
If I use:
This will not work as the domain ends in golf.com and it will not be matched. I guess I need to ignore any text after a dot, how can this be done?
domain like '%".mysql_real_escape_string($_GET['keywords'])."'