Search BY first name or last name or canacatination of first name and last name

named_scope :username_like, lambda { |value| {:conditions => ["first_name LIKE ? OR last_name LIKE ? OR CONCAT(first_name,' ',last_name) LIKE ?",value,value,value]} }