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
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 '%blub%' is too
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
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 suggestion :
]
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 has a simple search engine that allows a shopper to
type
in a search string
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