NYCPHP Meetup

[Jeff]

This seems to have worked!!!!

Here's the full query:

SELECT * FROM tblDealerSearchList WHERE (DE_bMakeLive = 1) AND
DE_sCategories LIKE '%,2,%' AND ( ( DE_sDescription LIKE "ford %"OR
DE_sDescription LIKE "% ford"OR DE_sDescription LIKE "% ford %") ) ORDER
BY DE_sTargetLevel DESC, DE_sCompanyName ASC 

Here are some of the results:
======
Bobs Ford Parts

90 and newer ford car parts. All years mustangs.
=======
Saved Auto Parts, Inc.

We specialize in factory takeoff Dodge and Ford parts.
======
Ace Antique Automotive

Ford Parts 1932-1953


=============================

Jeff


-----Original Message-----
From: John Adair [mailto:jadair at adairservices.net] 
Sent: Thursday, May 08, 2003 10:29 PM
To: NYPHP Talk
Subject: RE: [nycphp-talk] MySQL WHERE clause question


"Select * Where Description Like 'ford %' or like '% ford' or like '%
ford %'"

the first like finds 'ford ' at the beginning of the description. the
second like finds ' ford' at the end of the description. and the last
like finds the word 'ford' within the body that is surrounded by spaces.

I'm not the best at SQL though.

-----Original Message-----
From: Jeff [mailto:jsiegel1 at optonline.net]
Sent: Thursday, May 08, 2003 11:01 PM
To: NYPHP Talk
Subject: [nycphp-talk] MySQL WHERE clause question


This question concerns how to format a "WHERE" clause so that it only
finds those records that have a particular word buried within the text.
For example, if my WHERE clause has "DE_sDescription LIKE "%ford%" it
will return records that have the word "affordable" in the description
field. But if I remove the wild cards, then it doesn't find those
records that may have the word "ford" buried within a text (the text
runs 500 characters at the max).

Any pointers would be *greatly* appreciated.

Jeff












--- Unsubscribe at http://nyphp.org/list/ ---