This is another really good way to make a custom sql query in ZF2 with table gateway in the model...in this case a LIKE statement... :)

sql_like.php

    $adapter = $this->tableGateway->getAdapter();
		$select = new Select();
		$select->from('tax_tags')
			   ->limit(5)
			   ->where->like('tag', "%".$query."%");
		$statement = $adapter->createStatement();
		$select->prepareStatement($adapter, $statement);
		$result = $statement->execute();