class City extends AbstractTableGateway

CityTable.php

public function searchByName ($str)
	{
		$like = function (\Zend\Db\Sql\Where $where) use ($str)
		{
			$where->like('name', $str . '%');
		};

		$resultSet = $this->select(function (\Zend\Db\Sql\Select $select) use ($like)
			{
				$select->where(
					$like
				);
			}
		);

		return $resultSet;
	}