pharmacies.rb

# Option 1
pharmacies = []

Pharmacy.all.each do |pharmacy|
  if pharmacy.recurrent_days.present?
    recurrent_days = pharmacy.recurrent_days.split(',').map { |day| day.to_i }

    pharmacies << pharmacy if recurrent_days.include?(Time.now.wday)
  end
end

# Option 2
scope :todays, -> (q) { where([ "recurrent_days LIKE ?", "%#{q}%" ]) }
pharmacies = Pharmacy.todays(Time.now.wday)