Can Mysql 4.20 use an index where like 'xx%' is in the where
clause against the column.
i.e. index table1(col1)
from table1
where table1.col1 like 'something%'
Regards,
Ben
--
Ben Edwards - Bristol, UK
If you have a problem emailing me use
http://www.gurtlush.org.uk/profiles.php?uid=4
.
via a log file) are/have been run against the database. If it counts
how may times/how much resources each query uses that would be good.
The icing on the cake would be a prog that told us what queries were
doing full table scans and other expensive operations.
Regards,
Ben
--
Ben Edwards
how do I access the Data Dictionary through SQL? What I want to do is
loookup the length of a varchar for validation?
Ben
--
Ben Edwards - Poole, UK, England
WARNING:This email contained partisan views - dont ever accuse me of
using the veneer of objectivity
If you have a problem emailing me
--
* Ben Edwards Tel +44 (0)1179 553 551 ICQ 42000477 *
* Homepage - nothing of interest here http://gurtlush.org.uk *
* Webhosting for the masses http://www.serverone.co.uk *
* Critical Site Builderhttp://www.criticaldistribution.com *
* online collaborative web authoring
such a function, there probably is someone who has.
Ben
--
* Ben Edwards Tel +44 (0)1179 553 551 ICQ 42000477 *
* Homepage - nothing of interest here http://gurtlush.org.uk *
* Webhosting for the masses http
]
The procedure is quite slow, because for the 2nd step I have nnn queries
where nnn = number of rows in the 1st step.
Could you suggest a better and faster approach ?
--
* Ben Edwards Tel +44 (0)1179 553 551 ICQ
: www.mobilethink.dk
--
* Ben Edwards Tel +44 (0)1179 553 551 ICQ 42000477 *
* Homepage - nothing of interest here http://gurtlush.org.uk *
* Webhosting for the masses http
, if you can order the query, is to use the LIMIT clause
(mysql specific). LIMIT x,y, x=first row and y=number of rows. So if
you ordered your query with the row you wanted first add LIMIT 1,1 at
the beginning.
Ben
--
* Ben Edwards
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
* Ben Edwards Tel +44 (0)1179 553 551 ICQ 42000477 *
* Homepage - nothing of interest here http
to minimize chance of this module erroring
$to = CriticalDistribution [EMAIL PROTECTED];
$from = From: .$to;
mail($to, $subj, $msg, $from);
die();
}
--
* Ben Edwards Tel +44 (0)1179 553 551 ICQ
).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
* Ben Edwards +44 (0)117 968 2602 *
* Critical Site Builderhttp://www.criticaldistribution.com *
* online collaborative web authoring
Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
still using V3 and don't have any timescales for upgrading?
Ben
* Ben Edwards +44 (0)117 968 2602 *
* Critical Site Builder
:http://lists.mysql.com/[EMAIL PROTECTED]
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
* Ben Edwards
and effort on the
part of staffs that are already under a great deal of pressure to do
more with less. Again not authoritative for those specific org's but
these problems are close to universal in the space.
Scott Helms
On Mon, 2003-03-31 at 12:00, Ben Edwards wrote:
Anyone know why the two ISPs I use
Could anyone please let me know how to set the min word lenght to 3 for
Free Text search, I am using PHP.
Ben
Regards,
Ben
* Ben Edwards +44 (0)117 968 2602 *
* Critical Site Builderhttp
having problems working out sql where exists syntax.
Tried
select *
from sections s
where exists (
select 0
from pages s
where s.page = p.page
)
Any ideas,
Ben
--
[EMAIL PROTECTED]+44 (0)7970 269
Get the pdf version from php.net.
At 01:02 P 21/10/01, DL Neil wrote:
Hi
Maybe it is in the manual, but i canĀ“t find it in the way i need.
Does anybody know where to find a complet list of MySQL error codes with
number and descripcion in order to make a library for handling and
reporting alerts
afford our own box.
The latest documentation categorically states there is no other way of
changing this.
**
* Ben Edwards+352 091 429995 *
* Homepagehttp://www.gifford.co.uk/~bedwards
looking for an alternative which can be implemented
on php4. Has anyone any suggestions?
Ben
3.23.41-log
Also in the manual it mentions freetext search
**
* Ben Edwards+352 091 429995 *
* Homepage
this douse not help me in the immediate future and I still need to
find a alternative fullsearch method.
Ben
**
* Ben Edwards+352 091 429995 *
* Homepagehttp://www.gifford.co.uk/~bedwards *
* i
and MySQL (actually installed 3.23.42) after first de-installing PHP but
still no luck.
Regards,
Ben
--
This Email account is protected by http://www.spamcop.net
ALL spam is reported to ISP and there network provider
*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+
* Ben Edwards
and there network provider
*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+
* Ben Edwards [EMAIL PROTECTED] +352 091 429995 *
* Homepagehttp://www.gifford.co.uk/~bedwards *
* i-Contact Progressive Videohttp://www.videonetwork.org *
* Smashing the Corporate
22 matches
Mail list logo