|
|
Posted by Amir Mohammad Saied on 10/21/89 11:21
Brent Baisley wrote:
> Sounds like you want to use full text indexing. Create one full text
> index spanning name, area, organisation. Then search on all three
> fields at once.
> SELECT * FROM sheet1 MATCH(name,area,organisation) AGAINST ('textstring*
> otherstring* etc*). The * means use LIKE searching. There are a bunch
> of other options you can use and also limitations. Read the manual for
> all the details.
>
>
> On Jul 14, 2005, at 4:37 AM, Ross wrote:
>
Just to remember!
this method works just with MyISAM table types.
Navigation:
[Reply to this message]
|