Steve Edberg wrote:
> At 11:23 PM +0800 6/30/07, Niu Kun wrote:
>
> To quote from
>
> http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
>
>
> "... words that are present in more than 50% of the rows are considered
> common and do not match."
>
> 'hello' appears in both (100%) of
Octavian Rasnita wrote:
> Hi,
>
> Try:
>
> select * from test where match(name) against("hello" in boolean mode);
>
> Octavian
Thank you for your suggestion. I tried, but failed.:(
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
Hi,
Try:
select * from test where match(name) against("hello" in boolean mode);
Octavian
- Original Message -
From: "Niu Kun" <[EMAIL PROTECTED]>
To:
Sent: Saturday, June 30, 2007 6:23 PM
Subject: Problem about fulltext search.
Dear all,
I'm planning to add fulltext search to my
At 11:23 PM +0800 6/30/07, Niu Kun wrote:
Dear all,
I'm planning to add fulltext search to my database.
I've got the following test command:
create table test(id int, name varchar(20));
alter table test add fulltext(name);
insert into test values(1,"hello world");
insert into test values(1,"hell
Dear all,
I'm planning to add fulltext search to my database.
I've got the following test command:
create table test(id int, name varchar(20));
alter table test add fulltext(name);
insert into test values(1,"hello world");
insert into test values(1,"hello");
When I execute the fulltext search com
Rich wrote:
Ah that makes sense. It's a double shot, first grabbing the necessary
records, then selecting all in that temp value (hitlist) in reverse order.
Well done.
Cheers
On Jun 30, 2007, at 11:26 AM, Octavian Rasnita wrote:
Hi,
Try something like this:
select * from (select * from t
Ah that makes sense. It's a double shot, first grabbing the
necessary records, then selecting all in that temp value (hitlist) in
reverse order.
Well done.
Cheers
On Jun 30, 2007, at 11:26 AM, Octavian Rasnita wrote:
Hi,
Try something like this:
select * from (select * from table_name
On Jun 30, 2007, at 9:06 AM, Borokov Smith wrote:
Hey,
Why is ORDER BY in combination with LIMIT not a valid solution to
your problem ?
Greetz,
Hi there.
Because if I choose ASC it chooses the first X records, and if I
choose DESC it chooses the last X records, but in reverse order.
Hi,
Try something like this:
select * from (select * from table_name where ... order by last_update desc
limit 10) as tbl order by tbl.last_update;
Octavian
- Original Message -
From: "Rich" <[EMAIL PROTECTED]>
To: "Submit MySQL"
Sent: Saturday, June 30, 2007 3:45 PM
Subject: Sele
1.Software Name:Network Monitor Gateway V2.1
2.Development Language:C++ Builder
3.Database Support:MS SQL Server
4.System Requirement: Windows 2000 Server/Windows 2003
5.Product Content:We provide the software's complete source or
further-development and detailed using guide. Please Contact Us If
1.Software Name:Cyber Data Recorder Client/Server V1.5
2.Development Language: VC++
3.Database Support:MS SQL Server
4.Required Environment For Server:Windows 2000/ XP/ 2003
5.Required Environment For Client:Windows 2000/ XP/ 2003
6.Product Content:We provide our software's complete source or
furt
1.Software Name:Network Monitor Sniffer V2.0
2.Development Language:C++ Builder
3.Database Support:MS SQL Server
4.System Requirement:Windows 2000,Windows XP,Windows 2003
5.Product Content:We provide our software's complete source or
further-development and detailed using guide for it. Please Cont
Rich schreef:
Hi folks.
Just wanting to know the best way to grab the last 10 rows from a
table. Looking twice to the db to see how many records there are will
be outdated by the time the SELECT is done, so it's moot. This is a
fast moving db with records coming and going.
Instead of havi
Hi folks.
Just wanting to know the best way to grab the last 10 rows from a
table. Looking twice to the db to see how many records there are
will be outdated by the time the SELECT is done, so it's moot. This
is a fast moving db with records coming and going.
Instead of having an offset
14 matches
Mail list logo