Posted by Mike P2 on 05/16/07 20:14

On May 16, 3:19 am, "Robertu" <r...@nospam.com> wrote:
> Hi
> I am sorry but my english is very bad
> I must make a mysql_query selecting some records from a table
> My selectiom must select only records that contain a certain phrase stored
> into a fierld memo that can be very long
> How can I weite because mysql understand that I want to search the phrase
> stored into the lonh char fields:
> select * from my table where my_field_memo contain "phrase contained into"
>
> Undertstand now?
>
> Regards

If you are searching TEXT fields, MySQL supports full-text indexing
and searching.

More information:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

-Michael Placentra II

[Back to original message]