QuoteSQL

[Lawrence D'Oliveiro]

In message <slrnehhr8n.ln4.sybrenUSE at schuimige.stuvel.eu>, Sybren Stuvel
wrote:

> Lawrence D'Oliveiro enlightened us with:
>> The trouble with this is that, instead of offering extra functionality,
>> it leaves the door open to making two stupid mistakes:
>>
>>     2) quoting of wildcards BEFORE quoting of non-wildcards
> 
> Why is this a "stupid" mistake in your view? Please explain this in
> detail, because I think it's a proper way of doing it.

Because quoting the wildcards introduces backslash specials before each
wildcard. Quoting non-wildcards then causes those backslashes to be
doubled, which means they escape themselves instead of the wildcards.