Zak Mandhro

technology = evolution; open source = punctuated equilibrium

  • Home

20

Nov

Using MySQL Full Text Search with Rails

Posted by Zak Mandhro  Published in rails, ruby

MySQL offers powerful out-of-the-box full text search capability. It allows you to do advanced search on text columns such as:
apple +computer -fruit
As of Rails 1.1.6, working with MySQL Full Text search is not that straight forward. The first problem is that Migrations doesn't support the SQL syntax for full text indexes. Your create table class [...]

Continue reading...

7 comments

Zak Mandhro
View Zak Mandhro's profile on LinkedIn

My Products

  • BabyBook.me Twitter + Facebook powered memory book and live journal
  • Famiva.com Social Network for Families
  • ROXML Ruby Objects for XML
  • uddi4r UDDI for Ruby

RSS Zak's Twitter Feed

  • Hey, the Twitter.com web interface is actually useful now. about 21 hours ago from web
  • Are you attending Chirp - Twitter Developer Conference? Drop me a note! http://chirp.twitter.com/ 10:22:51 AM March 09, 2010 from LinkedIn
  • Damn it. Another year that I didn't get a chance to go to SXSW. 11:13:37 PM March 08, 2010 from LinkedIn
  • Another great day at the San Mateo park. 20 minutes away and 15 degrees warmer! 09:10:02 PM March 06, 2010 from threadsy
  • Currently looking for rockstar Ruby developers in San Fran for VC-backed startup. Interested? http://bit.ly/aVcFGA 11:50:19 PM March 05, 2010 from LinkedIn
  • Feels good to be back in San Francisco. I am actually enjoying BART. 11:32:49 AM February 01, 2010 from Twitterrific
  • Listening to Atif Aslam makes me seriously nastolgic. #karachi 03:14:46 PM December 12, 2009 from Twitterrific
  • Time Machine Restore broke Quick Look for 10.6.2. Fix it by reinstalling update. http://bit.ly/4tF57G 04:17:36 PM November 26, 2009 from Tweetie
  • This just in: Microsoft announced it will release Internet Explorer OS to compete with Chrome OS. No, you will not be able to uninstall IE. 04:02:52 PM November 22, 2009 from Tweetie
  • Chrome OS seems nothing more than a browser with a plugin running on a mini Linux. 04:27:07 PM November 20, 2009 from Tweetie

RSS Famiva Blog

  • Bug fix with invitation acceptance
  • Back Online
  • You’re In Control - Give Us Feedback!
  • Sampa Migration Now Available
  • Migrate from Sampa to Famiva - automatically!
  • Happy Father’s Day Gift - BabyBook.me
  • We’re Back
  • Introducing GEDCOM Import
  • What’s new with Famiva.com
  • New feature: Universal member search

Recent Entries

  • BabyBook.me – My Latest Project
  • Sign-up for Firefox Download Day
  • SOA with Ruby
  • 8 things Mac OS could do better
  • Leopard delayed. Time to get a Mac.
  • Family2.0 Famiva is live, FINALLY!
  • Edgy on Rails? Get compiling!
  • SD Times – Rails for Tactical Business Applications
  • Using MySQL Full Text Search with Rails
  • Making Firefox work with Dual Screen on Linux

Recent Comments

  • Aaron Gough in Using MySQL Full Text Search with Rails
  • Ben in Family2.0 Famiva is live, FINALLY…
  • Zak Mandhro in 8 things Mac OS could do better
  • Zak Mandhro in 8 things Mac OS could do better
  • Zak Mandhro in 8 things Mac OS could do better
  • Carl Williams in 8 things Mac OS could do better
  • Mysql Download in Using MySQL Full Text Search with Rails
  • shaiton in Making Firefox work with Dual Screen on Linux
  • Tom in 8 things Mac OS could do better
  • coolpositive in Using MySQL Full Text Search with Rails
  • Random Selection of Posts

    • Sign-up for Firefox Download Day
    • SD Times – Rails for Tactical Business Applications
    • Family2.0 Famiva is live, FINALLY!
    • BabyBook.me – My Latest Project
    • Using MySQL Full Text Search with Rails
    • Edgy on Rails? Get compiling!
    • Designing Databases with ActiveRecord Conventions
© 2008 Zak Mandhro is proudly powered by WordPress
Theme designed by Roam2Rome