Re: [SQLObject] _likeQuote

[Ian B. <ia...@co...>]

Oleg Broytmann wrote:
> On Fri, Nov 05, 2004 at 02:41:55PM -0600, Ian Bicking wrote:
> 
>>Oleg Broytmann wrote:
>>
>>>Hello! Why double percent?
>>
>>CONTAINSSTRING hides the underlying wildcard implementation, quoting % 
>>as %%.
> 
> 
>    Quoting?

If you want to search for all fields that contain the text "100%" 
(literally, not treating % as a wildcard) you would search for
field LIKE "%100%%%"

-- 
Ian Bicking  /  ia...@co...  /  http://blog.ianbicking.org