gistfile1.txt

CREATE TABLE halfak.searches
SELECT dt, ip, user_agent, uri_host, uri_query 
FROM webrequest 
WHERE 
  uri_query LIKE "%title=Special%3ASearch%" AND 
  uri_query LIKE "%search=%" AND
  uri_path = "/w/index.php" AND
  year = 2014;

Suggest tweak to:
CREATE TABLE halfak.searches
SELECT dt, ip, user_agent, accept_language, uri_host, uri_query
FROM webrequest
WHERE
uri_query LIKE "%search=%" AND
uri_path = "/w/index.php" AND
year = 2014 AND
month = 10 AND
day BETWEEN 01 AND 30 AND
webrequest_source = 'text' AND
http_status = '200';