I have an SQL query defined below which is a regex looking for a domain. This works great, however, I'm trying to get where it says stripe.co to reflect the value of the variable domain.

passwords_controller.rb

class PasswordsController < Test::BaseController

  def index

    records = AssetPassword.all

    
    domain = "google.com"
    records = records
                  .where("url ~ 'stripe.co([\/?]|$)'")
                  
    # the goal is to remove where it says stripe.co with a dynamic variable, so it could be ANY website/domain
                  
    render json: records
  end

The Goal here is something like:

records = records .where("url ~ '?([\/?]|$)'", domain)

This doesn't work - but I'm looking for a similar solution.