Execute angular contoller function on page load
// register controller in html


// in controller
$scope.init = function () {
// check if there is query in url
// and fire search in case its value is not empty
};

Check out UI Bootstrap's pagination directive.
View
***


ng-model="currentPage"
total-items="todos.length"
max-size="maxSize"
boundary-links="true">



***
Controller
***
todos.controller("TodoController", function($scope) {
$scope.filteredTodos = []
,$scope.currentPage = 1
,$scope.numPerPage = 10
,$scope.maxSize = 5;

$scope.makeTodos = function() {
$scope.todos = [];
for (i=1;i<=1000;i++) {
$scope.todos.push({ text:"todo "+i, done:false});
}
};
$scope.makeTodos();

$scope.$watch("currentPage + numPerPage", function() {
var begin = (($scope.currentPage - 1) * $scope.numPerPage)
, end = begin + $scope.numPerPage;

$scope.filteredTodos = $scope.todos.slice(begin, end);
});
});
***
I have made a working plunker for reference.

Legacy Version:
View
***





Controller
todos.controller("TodoController", function($scope) {
$scope.filteredTodos = []
,$scope.currentPage = 1
,$scope.numPerPage = 10
,$scope.maxSize = 5;

$scope.makeTodos = function() {
$scope.todos = [];
for (i=1;i<=1000;i++) {
$scope.todos.push({ text:"todo "+i, done:false});
}
};
$scope.makeTodos();

$scope.numPages = function () {
return Math.ceil($scope.todos.length / $scope.numPerPage);
};

$scope.$watch("currentPage + numPerPage", function() {
var begin = (($scope.currentPage - 1) * $scope.numPerPage)
, end = begin + $scope.numPerPage;

$scope.filteredTodos = $scope.todos.slice(begin, end);
});
});
***

Try using the REPLACE function:
***
mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'
***

You can use a User-defined function or a view instead of a procedure.

A procedure can return multiple result sets, each with its own schema. It's not suitable for using in a SELECT statement.