Most Efficient Query
| From: | Monty | Date: | Thu, 22 Jul 2004 08:14:43 +0000 |
| Subject: | Most Efficient Query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-191486@lists.php.net to get a copy of this message | ||
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