Mass Update Domain Registrar Using SQL Query

To bulk modify domain registrar in WHMCS, use the following SQL query template:


UPDATE tbldomains
SET registrar = 'registrarB'
WHERE registrar = 'registrarA';


Old registrar, to be updated: 'registrarA'
New registrar, replacing existing: 'registrarB'

Was this answer helpful?

 Print this Article

Also Read

Video: Configure General Settings in WHMCS

This video tutorial provides Step-by-Step instructions for installing WHMCS to your web hosting...

Install WHMCS with Softaculous

This article describes the process of installing WHMCS through the Softaculous Auto-installer...

Video: Configuring Currency Settings in WHMCS

This video tutorial provides Step-by-Step instructions for configuring the currency settings from...

Video: Securing the WHMCS Installation

This video tutorial provides Step-by-Step instructions for enhancing the security of a WHMCS...

Video: Setup WHMCS Cron Job for Task Automation

This video tutorial provides Step-by-Step instructions for setting up the WHMCS cron job to...