The original query is as follows:
SELECT * FROM websites WHERE category LIKE '%"&search&"%' OR keywords LIKE
'%"&search&"%' OR description LIKE '%"&search&"%'
The "&search&" instances are from an ASP page. 'search' is a variable that
is asigned the value of the query string 'search'
dim search
search = request.querystring("search")
Thanx. I'm hoping to test this on my database soon (the InnoDB)
**************
- Deryck Henson
- http://www.comp-u-exchange.com
**************
----- Original Message -----
From: "Deryck Henson" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, October 04, 2010 12:23 PM
Subject: InnoDB Tables/Databases
> OK, I will soon have a huge database, home to about 500,000,000+ records
and
> believe that MySQL needs to be faster. I have heard good things about
> InnoDB but Ihave no idea what it is. Can someone please tell me (or give
a
> url telling) what it is, the benifits, how I can set it up on an already
> existing database, and what it can do for me. Thank you. Also, if anyone
> knows a very good search query for this that would be good for a high-end
> search engine (google, yahoo, etc), please let me know. Thank You.
>
> **************
> - Deryck Henson
> - http://www.comp-u-exchange.com
> **************
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
