NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL WHERE clause question

Pinyo Bhulipongsanon pinyo at nyc.rr.com
Thu May 8 23:20:23 EDT 2003


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