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