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...

Laragon database Crashed! Easy Fix.

So your database crashed and it wont start? There can be many reasons behind that issue. Sometimes its just a bad luck (unfortunate error which brakes some file in database system).This happen to me few times and I had to deal with this issue like you now. After all...

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”,...

Mysql utf8_general_ci vs utf8_unicode_ci

Why to use utf8_unicode_ci over utf8_general_ci, or simple why never not to use utf8_general_ci. Basically utf8_general_ci is a broken version of utf8_unicode_ci. It is slightly faster bit only a little bit and it can produce unexpected result while sorting or...