Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

The Perfect "Search"


Go to End


761 Views

Avatar
TerryMiddleton

Community Member, 108 Posts

22 May 2009 at 12:35am

It seems that when doing a search the query looks for the searchtext using a 'Like' instead of an 'Equal'.

How can I get the search query to do an 'Equal'?

For example, if I search on radia then the results will be anything with the word raia in it.

Instead I want to search on radia and only get radia not radiation, radiate or anything else where radia is part of the work.

It seems that the query is (select * from table where field like 'radia*' instead of select * from table where field = 'radia';)

How can this be accomplished?

Terry