NYCPHP Meetup

[Ed McCarroll]

> "Select * Where Description Like 'ford %' or like '% ford' or
> like '% ford %'"

This won't find "Buy a ford."

I'm not an SQL expert, but I'm constantly dealing with similar issues
in a "search and replace" context.

Could you first pass the Description through a regexp that translates
all punctuation into spaces?  It could also put a space before and
after the Description, so that you could skip the "Like 'ford %'"
and "Like '% ford'" parts.

Regards,

  Ed

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                          MailTo:Ed at ComSimplicity.com
ComSimplicity                                      (310) 838-4330
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -