Mass Update Domain Registrar Using SQL Query

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

How to 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'

Conclusion

You now know how to mass update domain registrar using SQL query in WHMCS.

Related:

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

Related Articles

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 Enable Subdomain Options for a Product in WHMCS

This article provides a guide for how to enable subdomain options for a product in WHMCS. While...

How to Setup WHMCS Development and Testing Environment

Creating a testing and development environment will let you verify all of your customizations...