I'm writing a simple search script in PHP and wasn't sure whether the best
way to search for the records in MySQL was this way...

  SELECT * FROM db WHERE field1 LIKE "var%" OR field2 LIKE "var%" ...

...or would it be faster and more efficient to use fulltext indexes with
MATCH() and AGAINST()? I have MySQL 3.23.58 installed on my server.

Thanks!

- Monty

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to