NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL WHERE clause question

DeWitt, Michael mjdewitt at alexcommgrp.com
Fri May 9 09:28:38 EDT 2003


Another approach to this issue is to use MySQL's full text ability.  Details
can be found at http://www.mysql.com/doc/en/Fulltext_Search.html

Mike

> -----Original Message-----
> From:	John Adair [SMTP:jadair at adairservices.net]
> Sent:	Thursday, May 08, 2003 11: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/ ---
> 



More information about the talk mailing list