NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL WHERE clause question

Jeff jsiegel1 at optonline.net
Fri May 9 07:14:24 EDT 2003


That's the issue.

-----Original Message-----
From: Pinyo Bhulipongsanon [mailto:pinyo at nyc.rr.com] 
Sent: Thursday, May 08, 2003 10:20 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] MySQL WHERE clause question


Please clarify. You want be able to find this: "Meet me at the ford
dealership"

but not this: "This car is affordable"

Right?

----- Original Message ----- 
From: "Jeff" <jsiegel1 at optonline.net>
To: "NYPHP Talk" <talk at nyphp.org>
Sent: Thursday, May 08, 2003 11:01 PM
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/ ---






More information about the talk mailing list