That is fine.
On Thu, May 8, 2008 at 4:51 PM, Neil Tompkins <[EMAIL PROTECTED]>
wrote:
> Perfect. It worked just how I wanted.
>
> Thanks for your help.
>
> Neil
>
>
>
> > Date: Wed, 7 May 2008 19:54:39 +0200> To: [EMAIL PROTECTED]>
> Subject: Re:
Perfect. It worked just how I wanted.
Thanks for your help.
Neil
> Date: Wed, 7 May 2008 19:54:39 +0200> To: [EMAIL PROTECTED]> Subject: Re:
> Order Problem> From: [EMAIL PROTECTED]> > Hi,> > You should look at the
> `FIND_IN_SET` function here: >
>
Hi All,
I've the following query :SELECT ProductID FROM Products WHERE Enabled= ' Yes'
AND ProductID IN(varProductID)
This query works fine. However the query result is in a different order to
what I passed in varProductID.
How can I order the results based on my list like
varProductI
"Lee Denny" <[EMAIL PROTECTED]> wrote on 06/29/2005 08:00:49 AM:
> Hello,
>
> If got a simple sessions table basically holds a session id and datetime
> field for last modification also a session type, so I can have several
> records with the same session id, with different types and different
>
CTED]>
To:
Sent: Wednesday, June 29, 2005 8:00 AM
Subject: Simple GROUP / ORDER problem
> Hello,
>
> If got a simple sessions table basically holds a session id and datetime
> field for last modification also a session type, so I can have several
> records with the
Try adding max(session_modified).
SELECT *,max(session_modified) AS LastMod FROM translines GROUP BY
session_id ORDER BY session_modified DESC
On Jun 29, 2005, at 8:00 AM, Lee Denny wrote:
Hello,
If got a simple sessions table basically holds a session id and
datetime
field for last modif
Hello,
If got a simple sessions table basically holds a session id and datetime
field for last modification also a session type, so I can have several
records with the same session id, with different types and different
modification time. I want to get the latest modified record for any given
sess
>John:
>
>A couple of suggestions. First, a better way to identify duplicate files
> in to
>use MD5 sum - MySQL can compute it with MD5(LOAD_FILE(fname)) if the file
> is
>residing on the server. It would be a good idea to store the md5 sum in
> the table.
>
>I think your problem can be solved with
John:
A couple of suggestions. First, a better way to identify duplicate files in to
use MD5 sum - MySQL can compute it with MD5(LOAD_FILE(fname)) if the file is
residing on the server. It would be a good idea to store the md5 sum in the table.
I think your problem can be solved with
CREATE TEMP
Hello,
do any body can help me, i have problem with mysql syntax may be.
Let's first explain. I have two servers that i store filename, size
... in records of video camera files.
I have one database with two tables:
Servers and Files;
Servers contain:
ServerID, ServerName, User, Password, LastConne
Andy Eastham put me on the right track for this solution. I just ran the
following and it works so please give him the credit.
I tested with 'van der Plas' and 'McNeil'
SET @tmp = 'van der Plas';
SELECT @tmp,
Reverse(
SUBSTRING_INDEX(Reverse(@tmp),' ',1)
)
as myOrder
FROM MyTable;
Hi!
Anybody knows how can mysql ORDER BY international strings?
I would need to do sortings for different languages.
So locale definition should be changed within MySQL.
(changing locale for the system is not solution, because I need
to change more times for different languages)
How it is possibl
Hi.
On Tue, Jun 19, 2001 at 09:01:30AM -0700, [EMAIL PROTECTED] wrote:
> I'm generating a pulldown menu using PHP and MySQL. Originally I had the
> list order by model where it put everything in alphabetical order. I need to
> order them by year of model which luckily coincides with the order tha
I'm generating a pulldown menu using PHP and MySQL. Originally I had the
list order by model where it put everything in alphabetical order. I need to
order them by year of model which luckily coincides with the order that I
dumped them into the database so I would like to ORDER by id which was an
14 matches
Mail list logo
