Creating an INDEX on multiple tables?
| From: | Ron Piggott | Date: | Thu, 21 Oct 2010 08:43:53 +0000 |
| Subject: | Creating an INDEX on multiple tables? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47401@lists.php.net to get a copy of this message | ||
Is it possible to create one index on multiple tables? I am trying to create a search function for
my web site. The data the user needs to be able to search is stored in multiple tables. I would
like to be able to use "MATCH / AGAINST", like the query below I found online.
SELECT firstname, lastname,comments FROM users WHERE MATCH(firstname,lastname,comments) AGAINST
('$searchterm')
Ron