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

  • @kevinrose kindle is a device for reading books.. Why does it give up real state to keyboard? 11:03:10 PM July 28, 2010 from Flipboard in reply to kevinrose
  • Power.com awarded AlwaysOn 250 at Summit at Stanford. Kudos to Steve Vachani and Eric Santos. #sas10 09:05:50 AM July 28, 2010 from Twitter for iPhone
  • Verdict: TextMate with Rails + Git + Shoulda bundles is usable. But RubyMine does it all better. http://bit.ly/AsOhL 09:26:36 PM July 25, 2010 from Tweetie for Mac
  • Learning TextMate after ignoring it for years. http://bit.ly/94NhkC 11:31:50 AM July 24, 2010 from Tweetie for Mac
  • MailChimp design and UX is sensational! 11:23:50 PM July 23, 2010 from twitgether
  • Waiting for next @rubymine EAP. 96.552 is quite buggy. But then, it is EAP. http://bit.ly/dkKg3Q 06:13:03 PM July 23, 2010 from Twitter for iPhone
  • {LESS} rocks! CSS with variables, mixins, operations and nested rules http://www.lesscss.org 09:23:09 PM July 10, 2010 from web
  • Infinityward: you guys are f'ing amazing! Thank you for MW2. 12:37:51 AM July 10, 2010 from Twitter for iPhone

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

    • Family2.0 Famiva is live, FINALLY!
    • Making Firefox work with Dual Screen on Linux
    • Sign-up for Firefox Download Day
    • Setting up Intel Mac for Rails development
    • Designing Databases with ActiveRecord Conventions
    • Edgy on Rails? Get compiling!
    • Leopard delayed. Time to get a Mac.
© 2008 Zak Mandhro is proudly powered by WordPress
Theme designed by Roam2Rome