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

[Jefferis NoSpamme]

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.

Then entire query is:

SELECT *
FROM `Catalog`
WHERE `Catalog`.img_status = '1' AND `Catalog`.item_type ='R' AND
`Catalog`.item like '%A\-%'
ORDER BY `Catalog`.item_type

And will not work without the Like part

Thanks
Jeff
~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[Andy Hassall]

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

[Jefferis NoSpamme]

That is what I thought it was looking for

% 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

I forgot why I was looking for an A...

This is a rather complex php that pulls up any ring that has 3 views and
displays them, but if it doesn't have 3 views it only displays the single
image. The A is how the first image is indicated: Ring-1A.jpg
1B and 1C would be the alternate views.
Jeff

On 6/29/05 4:41 PM, in article gn********************************@4ax.com,
"Andy Hassall" <an**@andyh.co.uk> wrote:
equivalent.

~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----