[wp-trac] [WordPress Trac] #19525: Meta Query failing to build a proper SQL Query

WordPress Trac wp-trac at lists.automattic.com
Tue Dec 13 01:40:53 UTC 2011


#19525: Meta Query failing to build a proper SQL Query
--------------------------+------------------------------
 Reporter:  peshkohacka   |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Query         |     Version:  3.3
 Severity:  major         |  Resolution:
 Keywords:                |
--------------------------+------------------------------

Comment (by GaryJ):

 According to the
 [http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters
 documentation], the string "NOT BETWEEN" is not one of the supported
 comparison operators.

 Try rewriting as a meta_query, which has been available since 3.1 and
 which does allow "NOT BETWEEN" as the comparison string.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/19525#comment:2>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list