[wp-trac] [WordPress Trac] #56933: Unexpected quotes around search text in custom LIKE queries

[WordPress Trac]

#56933: Unexpected quotes around search text in custom LIKE queries
--------------------------+---------------------
 Reporter:  AlanP57       |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  6.1
Component:  Database      |     Version:  6.1
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+---------------------

Comment (by sethta):

 We are also getting the same issue on our plugin in the WP repo
 (mediavine-create).

 Because we didn't discover/confirm the issue until Friday, and this
 affects most of our SQL queries for the plugin, we know we can't QA a
 release to go out before WP 6.1 is released.

 The update to 6.1 breaks the ability to add or edit any custom content as
 we are using custom tables and have some `LIKE` queries that take place
 before we save to the database. Our solution is less than ideal as we have
 to adjust the prepare placeholder so it's just a string placeholder
 without any added `%%`, and then change the value to be `%%$value%%`.

 We have our QA team checking functionality right now so we can release
 soon, but we are currently advising publishers using Create to ''not''
 update to 6.1 until after we have pushed out a release.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/56933#comment:6>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform