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: [...]
0