NYCPHP Meetup

[Nasir Zubair]

Simplified version would be:
 
SELECT * FROM `table` WHERE `column` REGEXP "[[:blank:]]ford[[:blank:]]"
 
-------Original Message-------
 
From: talk at nyphp.org
Date: Thursday, May 08, 2003 11:29:32 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/ ---
 
 
 
 
.