|
Posted by Andy Hassall on 06/29/05 23:41
On Wed, 29 Jun 2005 16:34:47 -0400, Jefferis NoSpamme <jefferisp7@hotmail.com>
wrote:
>I am looking at an old query and I cannot remember or figure out what this
>part of the query means:
>
>`Catalog`.item like '%A\-%'
>It is the like '%A\-%'
>
>I cannot figure out.
% is a wildcard.
\ escapes a character.
So it's matching anything that has the string "A-" within the item field.
Don't know why the '-' is escaped, it's not a special character in LIKE
expressions - '%A-%' would appear to be equivalent.
--
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Navigation:
[Reply to this message]
|