|
Posted by Bob Stearns on 05/16/07 07:25
Robertu 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
>
>
The answer is both simple and tremendously expensive:
select *
from my table
where my_field_memo like '%phrase contained into%'
Navigation:
[Reply to this message]
|