WooCommerce SQL query for not empty tags

WordPress query non-empty tags or categories. Query only tags/categories that are assigned to a product. If you need to query tags or categories not particularly related to any tag category or product. You can go ahead and query data directly from two tables: wp_term...

MySQL – Regular expression replace

As of MySQL 8.0 and MariaDB 10 we can use  native REGEXP_REPLACE function. See also See MariaDB docs and PCRE Regular expression enhancements. — REGEXP_REPLACE(col, regexp, replace) SELECT REGEXP_REPLACE(“stackoverflow”,...