Can someone suggest me.. ? To make a keyword search from a specific field from a Table that have millions of rows. I used normal SQL query as follow
SELECT `field1`,`field2`,`field3` FROM 'table' WHERE `field5` LIKE '%keyword%1' AND `field5` LIKE '%keyword2%' (Field 5 is text and not an index field) Now my table have 170000 + and it took 3-7 second to process such query. Many Thanks. z.t.wai