Hi,
I currently have a table with 2 text fields, both of
which are marked as fulltext. I'm using the full-text
boolean search method with fairly good results.
My problems however are:
1. I am on a shared host provider so I can't tweak
the full-text search options such as stop words or
minimu
Have you tried "explain?" Have you indexed the table?
Curtis
On Sun, 8 Feb 2004, ___bug wrote:
> Hello,
>
>
> What is the best way to search a table with about 500.000 rows of varchar
> type.
> ---
> / id / time / name /
> ---
> Like '%blah%' and x Like '%blu
Hello,
What is the best way to search a table with about 500.000 rows of varchar
type.
---
/ id / time / name /
---
Like '%blah%' and x Like '%blub%' is too slow (takes about 20 sec)
I tried using a fulltext index and search by using MATCH() AGAINST()
The problem
A while ago we chatted about a better MySQL search engine. So I wrote a
script to turn the list into web pages, and indexed these and www.mysql.com
using the alkaline search engine.
the url is http://workinout.com:9998/workinout/search.html
Over time I will add improvements
a. produce
"Paul Maine" <[EMAIL PROTECTED]>
To: "MySQL MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, July 27, 2002 10:32 PM
Subject: PHP/MySQL Search Engine Query Question
> I am currently working on a website that is implemented using PHP and
MySQL.
>
> The site currently
Pada Sat, 27 Jul 2002 21:32:48 -0500
"Paul Maine" <[EMAIL PROTECTED]> menulis :
> $string ="1972 Ford Mustang"
>
> Using the following SQL statement:
> SELECT * FROM whatevertable WHERE whatevercolumn LIKE '%$search%
> I want to return all records that have Mustang AND 1972 AND Ford.
my sugges
I am currently working on a website that is implemented using PHP and MySQL.
The site currently has a simple search engine that allows a shopper to type
in a search string that is stored in $search. For example, if a shopper
types in 1972 Ford Mustang
$string ="1972 Ford Mustang"
Using the follo
