et without the limit OR make use
of count(*) and parse the result of count.
Since it only returns 10, it's correct the the total matched rows is 10.
sql query
Regards,
Jeroen Geusebroek
-
Before posting, please chec
If you are worried about security, don't run IIS! Now, that's
insecure! Use Apache, this also runs fine on windows.
PHP is as insecure as own programming is. If you program securely
then so is PHP.
My 2 cents.
-Original Message-
From: John Chang [mailto:johnec@;umich.edu]
Sent: vrijdag
why the isam table takes about 100
seconds for inserting 160K rows, while innodb takes 700 seconds. (using
individual inserts)
Thanks,
Jeroen
> -Original Message-
> From: Jeroen Geusebroek [mailto:j.geusebroek@;infraxs.com]
> Sent: Friday, October 25, 2002 3:11 AM
> To
>I agree that whatever the app is, having the ability to unplug the
>database (or for it to go down) and have there be a queue on the other
>machine is ideal. This will mean that even if the db machine reboots
>for whatever reason in the middle of the night, nobody will ever know
>the difference.
thing I should keep in mind when migrating?
Kind regards,
Jeroen Geusebroek
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi,
>May be because your LIKE query finds also
>'something will not shed any light on this!!!'
That's what i though just after posting this to the list.
When is the phrase support planned to be inserted in MySQL 4?
That would be a very nice feature!
Regards,
Jeroen
-
Hi there,
I'm trying to use fulltext for speeding up my queries, but i found some
strange
difference in the results between fulltext & Like ; for example:
AGAINST('+shed +some +light +on +this')
gives less matches then:
AND field LIKE '%shed%' AND field LIKE '%some%' AND field LIKE '%light%'
A
Hi there,
I am trying fulltext to speed up my queries; but what would the query
line be,
when I would like to match the phrase: "This is a text"?
With a like query i would do "WHERE column LIKE '%This Is a text%';"
I've tried "MATCH column AGAINST("'+this +is +a +test'");" but this
returns,
all
