NYCPHP Meetup

NYPHP.org

MySQL WHERE clause question

Jeff jsiegel1 at optonline.net
Thu May 8 22:58:40 EDT 2003


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







More information about the talk mailing list