Convert SQL code which works fine on MYSQL to MariaDB

When transitioning SQL queries from MySQL to MariaDB, specific SQL functions may behave differently or may not be supported. The existing SQL query uses MySQL-specific features like REGEXP_SUBSTR and REGEXP_REPLACE. In MariaDB, it's crucial to ensure that these functions are compatible or look for alternate ways to achieve the same result. Additionally, some expressions may need to be adjusted for MariaDB's syntax or capabilities to successfully extract and format phone numbers from various data columns.

The main difference between MySQL and MariaDB is that MariaDB has different implementations for certain functions used in extracting and formatting phone numbers.

Read at SitePoint Forums | Web Development & Design Community