Posted by Jefferis NoSpamme on 06/29/05 23:34

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 =----

• Next in forum: global
• Prev in forum: Moving to a modified URL
• Thread view: What does `Catalog`.item like '%A\-%' mean? -MySQL?

[Reply to this message]