some problems with search

[rymfiltre]

Hi everybody i want to thank you for all your help that really help me
i come here with a new question about the search function
is it possible to make the search not only in beging of the field but anywhere in this field
i explain what i want to do with a exemlpe :
the value in the field is : "sugarcrm" and when i search with "crm" i have got nothing in the result
is it possible to change this ? if yes who ?
thank you

[robertbmirth]

You can use the '%' character as a wildcard character. So searching '%crm' would find 'sugarcrm.'

[terencelhl]

You can use the '%' character as a wildcard character. So searching '%crm' would find 'sugarcrm.'

Dear Robert,

Does this include searching the street names? e.g. Street 1, 2, 3, etc.

From the newly installed sugar 6.0.3 with populated demo data, I can't get any result.

[robertbmirth]

Yes, it should, and its working for me. Make sure your search is cleared before you start - one kinda annoying thing about sugar's search is that its persistent so if you had a previous search (no matter how old) you're still searching for it unless you changed the fields or hit the clear button.

As I understand it (I can't verify this) and if you know anything about sql, the search is doing a 'like' comparison in the 'where' clause to find its results. I don't know if the '%' wildcard is universal to sql, so if you have anything besides mysql this also may be the source of the problem.