Geoff Coffey wrote:
>
> I am new here...
>
> I am in the process of migrating a site built with FileMaker Pro to MySQL
> and PHP mostly because filemaker's web capabilities are too limiting. In one
> situation, we have a database of about 20,000 rows that contains two text
> columns. One is the full text of a resume and the other is the full text of
> a cover letter. I'm trying to decide how to enable searching from a web
> form.
>
> I've not actually tried it, but I suspect using "LIKE" will be lousy. In
> Sybase it certainly would be. I found a thread on this list discussing just
> this, and the suggestion was made that I create a few tables to store
> keywords and map them to record ids etc. My problem with this is it makes it
> impossible to do searches on a phrase. I think the users would often search
> for "Microsoft Word" for instance, and it would find every candidate that
> mentions "Microsoft" and "Word", but not necessarily together. But it would
> be acceptable to limit it to word searches if need be (filemaker doesn't
> support this now in a fast way anyway). Are there any other options than
> this?
>
You can support phrases, using the keyword method you mention by first
generating a list of all docs that have your words using they keyword
method, you can then use LIKE '%Microsoft Word%' against the narrowed
list of documents.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
