Is it possible to search by keyword?

[spectheintro]

I'm having a lot of difficulty with the Search functionality in Sugar OS 4.5.1f.

I have an account called "The Tire Guys." I want to search for them out of around 1000 other accounts, using the Account search functionality. I put in a search for "tire" and nothing comes up. "Guys" produces a similar result. But a search for "the" pulls it up. Also, if I do a search using the general search at the top using "tire" or "guys" I get the same results. Ideally, any keyword would register in these searches, and any account/contact/etc with that keyword would pop up. That seems to be a very basic cornerstone of searching and I'm confused as to why it's not functioning. Am I doing something wrong?

[spectheintro]

After some more digging (I did about four searches on the forums before posting my original question; I guess 5th time's a charm...) I have found a temporary solution here. However, this isn't really ideal--I don't want my users to have to remember to insert a % before every search they do. Is there any way to insert this functionality manually into SugarCRM 4.5.1f, or do I need to wait for 5.0 to get this (very basic) functionality? Thanks.

[kbrill]

Edit the include/SearchForm/SearchForm.php file and at around line #335 you will see this

case 'like':
$where .= $db_field . " like '".$field_value.$like_char."'";
break;

Change it to this

case 'like':
$where .= $db_field . " like '".$like_char.$field_value.$like_char."'";
break;

[lvangool]

Will this bug be addressed in 5.0?

[kbrill]

Not really a bug, just the way it works.

[spectheintro]

Thanks for the response.

This fixed the problem for Accounts, but the top search bar (the one directly under the font size and color buttons) still functions the old way.