$sth->prepare(qq{
       SELECT name, url FROM table WHERE name LIKE %$name%});
##</code><code>##

$sth->prepare("SELECT * FROM companies WHERE name = ?");