Aliasing MySQL Functions with ActiveRecord

January 31, 2009

Changing column data to use MySQL functions instead of the actual column data for Ruby on Rails ActiveRecord is simple. To allow ActiveRecord to retrieve the data of the function,  alias it to the column name. Event.find :all, :select => ‘substring(name, 1, 10) as name’ This produces the follow SQL query using MySQL SUBSTRING function: [...]