[Rails] Re: how to search all fields for a string in SQL ?

2009-04-30 Thread Robert Walker
wbsurf...@yahoo.com wrote: Using SQL or activerecord I am not sure how to search all fields for a specific value ? I know how to do this by just writing ruby code. To do it in SQL or an activerecord find w/condition, I don't know how. I actually am supposed to combine an find w/ condition

[Rails] Re: how to search all fields for a string in SQL ?

2009-04-30 Thread Harold
I would suggest going with the thinkingsphinx plugin instead of ultrasphinx. Thinkingsphinx's syntax is much cleaner. http://ts.freelancing-gods.com/usage.html http://railscasts.com/episodes/120-thinking-sphinx On the other hand, if your dataset is small enough, you could try scoped-search,