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: Order Problem From: [EMAIL PROTECTED] Hi, You should
look
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:
http://dev.mysql.com/doc/refman/5.0/en/string
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
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
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
: 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 same session id, with different types and different
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
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
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,
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
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
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 that
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