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

Install WHMCS with Softaculous

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

Slow WHMCS Domain Spinner Whois Lookup

Slow WHMCS domain lookups are a source of frustration for some clients, as this, in turn, leads...

Video: Securing the WHMCS Installation

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

Video: Installing WHMCS

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

Video: Logging Into the WHMCS Admin Area

This video tutorial provides Step-by-Step instructions for logging into the WHMCS Admin area.