class DeleteAbsoluteFilenameImportedHitsFiles < ActiveRecord::Migration
  def up
    command = 'DELETE FROM imported_hits_files WHERE filename LIKE "/%";'
    ActiveRecord::Base.connection.execute(command)
  end

  def down
  end
end

class DeleteAbsoluteFilenameImportedHitsFiles < ActiveRecord::Migration
  def up
    command = "DELETE FROM imported_hits_files WHERE filename LIKE '/%';"
    ActiveRecord::Base.connection.execute(command)
  end

  def down
  end
end

Use single quotes for PG strings in migration
Use single quotes for PG strings in migration

* PG uses double quotes as table/column signifiers
