Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <rosuav@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.020
X-Spam-Evidence: '*H*': 0.96; '*S*': 0.00; 'arguments': 0.05; 'string,': 0.05; 'abstraction': 0.07; 'parsing': 0.09; 'statement.': 0.09; 'am,': 0.14; 'wrote:': 0.14; 'defined': 0.15; 'signs': 0.16; 'tue,': 0.20; 'header:In-Reply-To:1': 0.22; 'that?': 0.23; 'chris': 0.27; 'message-id:@mail.gmail.com': 0.28; "doesn't": 0.28; 'string': 0.29; 'query': 0.29; "can't": 0.31; 'to:addr:python-list': 0.32; 'character': 0.33; 'worry': 0.33; 'difference': 0.35; 'subject:use': 0.35; 'think': 0.36; 'received:209.85': 0.37; 'apr': 0.38; 'received:google.com': 0.38; 'but': 0.38; 'happens': 0.38; 'here,': 0.39; 'to:addr:python.org': 0.39; 'where': 0.39; 'received:209': 0.39; 'how': 0.39; 'header:Received:5': 0.40; '2011': 0.62; '26,': 0.68; 'escaping': 0.84; 'received:209.85.210.174': 0.84; 'received:mail- iy0-f174.google.com': 0.84
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type:content-transfer-encoding; bh=yogyIeaBm/t04PF2AuF7t8n1QYLrIiaMc/FulTgGFko=; b=CbUSq8Pb1L1gvx+mb1YLqAGkvsw8KdnJxr2ocaC1HvrOv1p2x3EIWmveKzrOFpI9hd /Kfd3/S7ox2bELlM+OHizmHFylShCHRTjgx3KrEM/uiqs2MjkzeBD2SEc8TnRMHeaqvo rQ6bzR/ojIfjaOBtTUHVP4agWMQFXmYME1vnA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=vTz8xsdJc364AO8cgxPFU2hqEESmpvS21k5L37TTGqtZtZXpNxvkjbnc+tUTmEu3q3 9hZhsz4mYbCAq2iEcsoFBXv+Q1azspLOoLXVkHcdTGyHJ4p/EK7LV+jromLD8Qt8rNg6 vEpvTELeHAW7h2CvvD1L5OhK3Sp0cPgAcBDPY=
MIME-Version: 1.0
In-Reply-To: <4db5ef2d$0$10574$742ec2ed@news.sonic.net>
References: <4dabf65a$0$18250$4fafbaef@reader2.news.tin.it> <mailman.505.1303116284.9059.python-list@python.org> <4db5ef2d$0$10574$742ec2ed@news.sonic.net>
Date: Tue, 26 Apr 2011 08:10:26 +1000
Subject: Re: strange use of %s
From: Chris Angelico <rosuav@gmail.com>
To: python-list@python.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.823.1303769429.9059.python-list@python.org>
Lines: 14
NNTP-Posting-Host: 82.94.164.166
X-Trace: 1303769430 news.xs4all.nl 81479 [::ffff:82.94.164.166]:39043
X-Complaints-To: abuse@xs4all.nl
Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:4005

On Tue, Apr 26, 2011 at 8:01 AM, John Nagle <nagle@animats.com> wrote:
> Don't worry about having MySQL do the CONCAT. =A0That happens
> once during query parsing here, because all the arguments to
> CONCAT are defined in the statement.
>

Good point. Although the abstraction is still a little leaky in that
you can't use this to search for a percent character anywhere in the
string (come to think of it, how _would_ you do that? I think you'd
have to backslash-escape it, prior to escaping it for the string, but
I'd have to check), so it doesn't make a lot of difference where the
percent signs are added.

Chris Angelico