Word searching 1. [code]SELECT * FROM table WHERE MATCH (`field`) AGAINST ('Keyword')[/code] (Fastest) 2.[code]SELECT * FROM table WHERE MATCH (`field`) AGAINST ('+Keyword' IN BOOLEAN MODE)[/code] (Fast) 3.[code]SELECT * FROM table WHERE RLIKE '(^| +)Keyword($| +)'[/code] OR [code]SELECT * FROM table WHERERLIKE '([[:space:]]|[[:<:]])Keyword([[:space:]]|[[:>:]])'[/code] (Slow) Contains searchi...
Read More »