Hi all,
I have to perform a mysql query in a table with millions of records.
I've full-text indexed my search field and I'm searching with MATCH AGAINST.
But there is a problem. In this field there are company names that
contain dots, for istance I've PO.SE. srl and I want to find it if
the
bharani kumar wrote:
Hi All ,
Am working on the autosuggestion program
SELECT $field2,$field1 FROM $tblname where locate('$q', $field2) 0 OR
locate('$q', $field1) 0 order by locate('$q', $field2),
$field2 limit . ($pagesize * $page) . , . $pagesize
This is my query ,
Example
Hi All ,
Am working on the autosuggestion program
SELECT $field2,$field1 FROM $tblname where locate('$q', $field2) 0 OR
locate('$q', $field1) 0 order by locate('$q', $field2),
$field2 limit . ($pagesize * $page) . , . $pagesize
This is my query ,
Example in my Database table
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
Hi all,
I'm fairly new to MySQL and PHP, but have been reading a few books and
experimenting a bit. I've created a php application that will allow me to
view all the fields in my Database, but have not been able to correctly
build a search function in it. Here's a little background on what
Greetings...
I am developing an application on MySQL using the MySQL API's.
I have .sql file with 1 insert statement. I want to run all the queries
in one shot. mysql_real_query() allows me to execute only one query at a
time ?
So what do you think is the best approach to execute all the
Hello,
I have a field named rights (varchar[9])
it contains some records like wrxwrxwrx or wr-w--w-x
I'd like to find all the records that contains this : wr??
That's why I did this query : SELECT * FROM table WHERE rights LIKE
'wr??'
and it doesn't work !
It extension, a simple
tristan Israel wrote:
Hello,
I have a field named rights (varchar[9])
it contains some records like wrxwrxwrx or wr-w--w-x
I'd like to find all the records that contains this : wr??
That's why I did this query : SELECT * FROM table WHERE rights LIKE
'wr??'
and it doesn't
in MySQL...
Check this page for more information.
http://www.mysql.com/doc/en/Pattern_matching.html
Best regards,
Mikhail.
- Original Message -
From: tristan Israel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 10:48 AM
Subject: mysql search
Hello,
I have
]
[EMAIL PROTECTED]
- Original Message -
From: tristan Israel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 11:48 AM
Subject: mysql search
Hello,
I have a field named rights (varchar[9])
it contains some records like wrxwrxwrx or wr-w--w-x
I'd like
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
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
For measuring relevance, you'll need to come up with our own weights and
algorithms. MySQL doesn't do that kinds of things. For more information,
read the documentation of Google at:
http://citeseer.nj.nec.com/brin98anatomy.html
or http://www7.scu.edu.au/programme/fullpapers/1921/com1921.htm
In the last episode (Oct 19), Barbara Ferrell said:
We have 3.3 million text documents ( U.S. Patents) that we can put
into any format needed to import into any database needed. Would
Mysql be able to handle fast FULLTEXT searching? Each document has
several fields that would need to be
- Original Message -
From: Barbara Ferrell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 19, 2001 6:51 PM
Subject: Fw: Can Mysql search full text fast through 3.3 million text
documents?
We have 3.3 million text documents ( U.S. Patents) that we can put into
any
20 matches
Mail list logo