[wp-trac] [WordPress Trac] #19738: meta_query should check for wildcards when using LIKE operator

[WordPress Trac]

#19738: meta_query should check for wildcards when using LIKE operator
-------------------------+-----------------------------
 Reporter:  ejdanderson  |       Owner:
     Type:  enhancement  |      Status:  reopened
 Priority:  normal       |   Milestone:  Future Release
Component:  Query        |     Version:  3.2
 Severity:  normal       |  Resolution:
 Keywords:               |     Focuses:
-------------------------+-----------------------------

Comment (by boonebgorges):

 Will - No, I don't think there's a particular danger, as long as you're
 only using operators like IN and =. (Things like BETWEEN and > will break
 if you require numeric cast.) It's actually a bit odd that we do this cast
 at all in the case of a default data type - I think we should look into
 skipping it.

 The bigger change is placing an index on the meta_value column, which
 could cause some serious performance issues on write actions at scale. But
 I think this is something that would be nice to benchmark a bit.

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