I love this one! (:>
That put a smile on a long night!
Thanks!
Daniel
> 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
>
---------------------------------------------------------------------
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
