Can't make the builder searchWhere use the complete search term!?

[jfoliveira]

Hi, after struggling trying to search for the exact search term I noticed that src/Database/Builder.php line 29 breaks the search term into words.

Giving that, how could we make OctoberCMS backend search widgets (relation widget, recordfinder widget, list widget, etc) perform a search returning the records containing the complete search term?

E.g.: if the search term is Jon Smith currently the builder retrieves all records containing Jon or Smith. So the search would return:

Jon Doe
John Smith
Jon Smith
Mary Smith
...

1. How could one make a search returning only records containing Jon Smith?
2. How could one set a search to return only records starting with Jon Smith?

Am I missing some settings that would make this possible?

Update 2016-04-18:
My previous example was not clear enough. If you have the following rows in your database:

John Smith
Jon Doe
Jon Paul Smith
Jon Smith
Mary Jon Smith
Mary Smith

...

and your search term is Jon Smith then the search would return:

Jon Paul Smith
Jon Smith
Mary Jon Smith

Whereas what I would need is the search to return only two records:

Jon Smith
Mary Jon Smith

[jfoliveira]

Is anyone able to help me with this issue? Any ideas?

[daftspunk]

This has been fixed by adding mode and scope to the list options. See Docs > List for more details.