Skip to content

Instantly share code, notes, and snippets.

@yanknudtskov

yanknudtskov/titlecase.sql

Created April 23, 2020 15:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save yanknudtskov/cba48dd568a76e3aa54968fc04e09a59 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save yanknudtskov/cba48dd568a76e3aa54968fc04e09a59 to your computer and use it in GitHub Desktop.
Download ZIP
Set Title case for all products in WooCommerce using SQL
Raw
titlecase.sql
UPDATE wp_posts SET post_title = LCASE( post_title ) WHERE post_type = 'product';
UPDATE wp_posts SET post_title = CONCAT( UCASE( LEFT(post_title, 1) ), SUBSTRING(post_title, 2) ) WHERE post_type = 'product';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment