[wp-hackers] WP 3.5.2/multisite: How to use NOT IN in $wpdb->prepare()?

Jerry Milo Johnson jmiloj at gmail.com
Tue Jul 16 02:51:42 UTC 2013


from what I can see from this trac discussion, they decided that prepare
won't handle this case:

http://core.trac.wordpress.org/ticket/11102

hth,
Jerry Milo Johnson


On Mon, Jul 15, 2013 at 10:43 PM, Micky Hulse <mickyhulse.lists at gmail.com>wrote:

> On Mon, Jul 15, 2013 at 7:36 PM, Micky Hulse <mickyhulse.lists at gmail.com>
> wrote:
> > With that said, how can I accomplish my goal of passing several blog
> > IDs into a query that uses wpdb::prepare() (like my example above)?
>
> I should say:
>
> What's the most practical and secure way (I want to avoid little Bobby
> Tables http://xkcd.com/327/) to pass a list of blog IDs into the NOT
> IN clause of wpdb::prepare() SQL statement?
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>


More information about the wp-hackers mailing list