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.u
.
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
ls and
something like the above may help.
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://www.serverone.co.uk *
* Critical Site Builderhttp://www.critica
> ---
> > What am I missing? Thanks
> >
> > - Mark
> >
> > --
> > Mark Wilson, Computer Programming Unlimited (cpuworks.com)
> > Web : http://cpuworks.com Tel: 410-549-6006
> > Email: [EMAIL PROTECTED] Fax: 410-549-4408
> >
> >
> >
> >
>
function.
The other option, 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
--
****
gt; Søren Neigaard
> System Architect
>
> Mobilethink A/S
> Arosgaarden
> Åboulevarden 23, 4.sal
> DK - 8000 Århus C
> Telefon: +45 86207800
> Direct: +45 86207810
> Fax: +45 86207801
> Email: [EMAIL PROTECTED]
> Web: www.mobilethink.
ult[max_date] AND
> Q.id_currency = $result[id_currency]
>
>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 approa
manual or download it. Can't quite remember but I think
there is an hour between function, go to php.net and look at the
date/time function bit. If not try looking on the net for someone who
has already written such a function, there probably is someone who has.
Ben
--
**
x27;";
$subj = "CritDist App error from $SERVER_NAME";
// Hard coded to minimize chance of this module erroring
$to = "CriticalDistribution <[EMAIL PROTECTED]>";
$from = "From: ".$to;
mail($to, $subj, $msg, $from);
die
f time 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
mysql
To unsubscribe: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
**********
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 Bu
virus system (http://www.grisoft.com).
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
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 query
select *
from sections s
where exists (
select 0
from pages s
where s.page = p.page
)
Any ideas,
Ben
--
[EMAIL PROTECTED]+44 (0)7970 26
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 5
l 4 out. Will email them. Thanks for
>the info.
>
>However this douse not help me in the immediate future and I still need to
>find a alternative fullsearch method.
>
>Ben
******
* Ben Edwards+3
on
hardcore commercial users who can't afford our own box.
The latest documentation categorically states there is no other way of
changing this.
**********
* Ben Edwards+352 091 429995 *
* Homepage
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 a
I am 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 *
* Hom
mcop.net
ALL spam is reported to ISP and there network provider
*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+
* Ben Edwards [EMAIL PROTECTED] +352 091 429995 *
* Homepagehttp://www.gifford.co.uk/~bedwards *
* i-Contact Progressive Videohttp://www.vid
e-installed both PHP
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
*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+
23 matches
Mail list logo
