Question: In this situation, I want to find all records that contain the name steve in one column and email@email.com in another. I know Im missing an operator, but i dont know which

```
            SELECT firstname,lastname,middlename,company_name, 
                    primary_emailaddress,alternate_emailaddress,personal_address_line1,
                    personal_address_line2,personal_address_city,facebook_username,
                    twitter_username,googleplus_username,linkedin_username,
                    personal_website_url,birthday_month,notes,personal_address_zipcode,
                    company_address_zipcode,home_phonenumber,company_phonenumber,
                    cell_phonenumber,birthday_day,birthday_year,hash,image_file
             FROM contacts
             WHERE (
                MATCH(
                    firstname,lastname,
                    primary_emailaddress,alternate_emailaddress,personal_address_line1,
                    personal_address_city,company_name,
                    company_address_line1,company_address_city,
                    facebook_username,twitter_username,googleplus_username,linkedin_username,
                    personal_website_url
                )
                AGAINST ('Steve email@email.com' IN BOOLEAN MODE))

```

Answer: 
Ok, after a lot of searching. I answered my own question.

I've discovered finding anything on the angular documentation is incredibly impossible, but sometimes, once it's found, it changes how you were thinking about your problem.

I began here: <http://docs.angularjs.org/api/ng>.$location
Which took me here: <http://docs.angularjs.org/guide/dev_guide.services>.$location
Which took me to this question: [AngularJS Paging with $location.path but no ngView reload](https://stackoverflow.com/questions/12422611/angularjs-paging-with-location-path-but-no-ngview-reload)

What I ended up doing:
I added `$location.search({name: 'George'});` To where I wanted to change the name (A $scope.$watch).

However, this will still reload the page, unless you do what is in that bottom StackOverflow link and add a parameter to the object you pass into `$routeProvider.when`. In my case, it looked like: `$routeProvider.when('/page', {controller: 'MyCtrl', templateUrl:'path/to/template', reloadOnSearch:false})`.

I hope this saves someone else a headache.
I actually found a solution that I find a little more elegant for my application.

The $locationChangeSuccess event is a bit of a brute force approach, but I found that checking the path allows us to avoid page reloads when the route path *template* is unchanged, but reloads the page when switching to a different route template:

```
var lastRoute = $route.current;
$scope.$on('$locationChangeSuccess', function (event) {
    if (lastRoute.$$route.originalPath === $route.current.$$route.originalPath) {
        $route.current = lastRoute;
    }
});

```

Adding that code to a particular controller makes the reloading more intelligent.