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.
You can change the display of the page using ng-show and ng-hide, these transitions won't reload the page. But I think the problem you're trying to solve is you want to be able to bookmark the page, be able to press refresh and get the page you want.

I'd suggest implementing angular ui-router Which is great for switching between states without reloading the page. The only downfall is you have to change all your routes.

[Check it out here](https://github.com/angular-ui/ui-router) theres a great demo.