FIND TITLES and SKU that are all in capital letters ? Possible ?

  • Resolved budrwo

    (@budrwo)


    6 years ago

    FIND TITLES and SKU that are all in capital letters ? Possible ?

    hello,

    I have a problem on my shop with thousands products, i would like to list the Titles and sku that are not Proper Case, because some are in CAPITAL LETTERS.

    Do you know how I could achieve this ?

    Thank you again for the best plugin ever ! (I just said it in my review!)

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author pimwick

    (@pimwick)

    The data stored in the database is case-insensitive. With that said, it would be possible to temporarily hack the plugin so that it will perform a case-sensitive search.

    If you are comfortable with editing PHP files, make a change to this file:

    /wp-content/plugins/pw-bulk-edit/includes/sql-builder.php

    Inside you will find a function called string_search. Look for the ‘contains’ condition and replace the “LIKE” statement with “LIKE BINARY”.

    For example:

    case 'contains':
    return $wpdb->prepare("$field_name LIKE BINARY %s", '%' . $value . '%');

    Note: this change will be overwritten whenever you update the plugin.

    Hope this helps you achieve your task!

    Plugin Author pimwick

    (@pimwick)

    Marking this thread as Resolved but let me know if you have any further questions.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘FIND TITLES and SKU that are all in capital letters ? Possible ?’ is closed to new replies.