Mass Update Domain Registrar Using SQL Query

This article provides a guide to mass update domain registrar using SQL query in WHMCS.

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'

  • sql query, domain registrar
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Video: Setup Administrative Roles in WHMCS

This video tutorial provides Step-by-Step instructions for setting up administrator roles within...

Slow WHMCS Domain Spinner WHOIS Lookup

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

List of Banned Subdomain Prefixes

This article provides suggestions for the Banned Subdomain Prefixes field of WHMCS administrative...

Synchronize Server Time with WHMCS

This tutorial provides a step-by-step guide for synchronizing server time with WHMCS billing...


WHMCS, a billing and support software for the web hosts, may experience a conflict with default...