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
  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

Slow WHMCS Domain Spinner WHOIS Lookup

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

Synchronize Server Time with WHMCS

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

Remove STRICT_TRANS_TABLES in SQL Mode for WHMCS

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

Get WHMCS Support

This article provides a guide for how to get WHMCS support for licenses purchased from Rad Web...

How To Login To The WHMCS Admin Area

This article provides a guide demonstrating how to login to the WHMCS Admin Area. Prerequisites...