[wp-trac] [WordPress Trac] #10041: like_escape() should escape backslashes too

[WordPress Trac]

#10041: like_escape() should escape backslashes too
---------------------------------+-----------------------------
 Reporter:  miau_jp              |       Owner:
     Type:  defect (bug)         |      Status:  reopened
 Priority:  high                 |   Milestone:  Future Release
Component:  Formatting           |     Version:  2.8
 Severity:  normal               |  Resolution:
 Keywords:  4.0-early has-patch  |     Focuses:
---------------------------------+-----------------------------

Comment (by miqrogroove):

 Replying to [comment:28 Denis-de-Bernardy]:
 > make it clearer that it's not actually escaping anything, but merely
 quoting LIKE special chars.

 I considered this again.  Remember, escape is the verb used in SQL, i.e.

 {{{LIKE '25\\% of \'people\'.'}}}

 is the default equivalent of

 {{{LIKE '25\\% of \'people\'.' ESCAPE '\\'}}}

 but we could specify

 {{{LIKE '25@% of \'people\'.' ESCAPE '@'}}}

 so yes, we are actually escaping things in this context.

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