Woocommerce MySQL snippets

Bolt sizes:

select reverse(substring_index(reverse(pm_sku), '.', 1))
from vProductMetaData
where (pm_sku like 'BO.%' or pm_sku like 'SCW.%');