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.

General Questions /

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

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

The Perfect "Search"


Reply


536 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