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 u
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 tab
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
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 qu
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 I
PROTECTED]
[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 means everything that
begins from 'wr')
Next point:
'?' - it is not pattern 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" &l
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??'
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
"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
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
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
C
Hi guys,
is there a method in mysql to do a search engines like query and order the
results
by relevance?
i taken a look at MATCH ... AGAINST function but i'm not sure that it's what
i need and i'm also looking for somenthing simpler and faster...
any idea?
thanks in advance
---
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. Pate
21 matches
Mail list logo
