Re: What does `Catalog`.item like '%A\-%' mean? -MySQL?

On Wed, 29 Jun 2005 16:34:47 -0400, Jefferis NoSpamme <jefferisp7@xxxxxxxxxxx>
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@xxxxxxxxxxx> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
.

Relevant Pages

  • Re: strange sql results on sysobjects
    ... _ is a special character (denotes that any character can be in that spot). ... SQL Server MVP ... >I am running the following query... ...
    (microsoft.public.sqlserver.programming)
  • Re: Change special characters
    ... > Create a query that replaces these characters with a space, ... >> I have a memo field where the user typed in data with line ... >> query to find the special character within the memo field ...
    (microsoft.public.access.queries)
  • Timeout expired
    ... I'm facing a problem after i upgrade sql version from 7.0 ... Same query is running in both version, ... all the 'TxnType' can loop through ... of the special character of '/'??(other TxnType don't have ...
    (microsoft.public.sqlserver.programming)
  • Re: Criteria Line of a field
    ... > query, is there SOME WAY at run time that that prompt can be ignored OR is ... > there a special character that can be entered that shows ALL the records then? ... I do not reply to personal email. ...
    (microsoft.public.access.queries)
  • Re: Identifying fields out of order
    ... Click on "Create Query in Design View" ... tblSeq AS Prev, tblSeq AS Next; ... Our SQL now would look like: ...
    (microsoft.public.access.queries)