Try your query with either back quotes around Company
SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes REGEXP
^R and gold_id=2 ORDER BY `Company` ASC
Or no quotes around Company
SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes REGEXP
^R and gold_id=2 ORDER BY
- Original Message -
Subject: RE: ORDER BY problem
Try your query with either back quotes around Company
SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes
REGEXP
^R and gold_id=2 ORDER BY `Company` ASC
Or no quotes around Company
SELECT * FROM Contacts WHERE
Hi,
the order comes out of sequence showing 10.11.12.13 etc before the number 2---
Can anyone help me out
That's because you are sorting the result on a string
(char/varchar) column. Try using CAST to convert it to
int or something similar: ORDER BY cast(column as unsigned)
Best
At 20:27 +0800 9/7/06, M B Neretlis wrote:
the order comes out of sequence showing 10.11.12.13 etc before the number 2---
Can anyone help me out
?php
//get user tips
$query = @mysql_query(SELECT * FROM tips WHERE user_id = $user_id
AND comp_id = $comp_id ORDER by round DESC);
while
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 10 September 2004 18:00, Ren Fournier wrote:
I've got a SELECT statement that is returning the data I want, but not
in the right order (and I don't know why...). Let's say there are two
tables, People and History. Some records in People
At 17:00 -0600 9/10/04, René Fournier wrote:
I've got a SELECT statement that is returning
the data I want, but not in the right order (and
I don't know why...). Let's say there are two
tables, People and History. Some records in
People have corresponding records in History,
but not all--so I
: Mysql List
Subject: RE: RE - Order By Problem
On Tue, 8 Jun 2004, Andy Eastham wrote:
Look at using the Reverse() function, then take the substring up to the
first space, then reverse the result.
Well, 'select substring_index(surname,' ',-1) from advisers' does the
trick as far
- Order By Problem
I have never done anything like this but after looking at the spec's I
have a possible direction for you
In String functions there is LOCATE(substr,str,pos)
The first syntax returns the position of the first occurrence of substring
substr in string str. The second syntax
andy thomas wrote:
snip
Well, this was fixed in the end by this query:
select substring_index(surname,' ',-1) as r from advisers order by r
which produced the desired result. But we have since had complaints from
individuals wanting their surnames sorted differently! People from Germany
with
I have never done anything like this but after looking at the spec's I have
a possible direction for you
In String functions there is
LOCATE(substr,str,pos)
The first syntax returns the position of the first occurrence of substring
substr in string str. The second syntax returns the position
On Tue, 8 Jun 2004, Paul McNeil wrote:
I have never done anything like this but after looking at the spec's I have
a possible direction for you
In String functions there is
LOCATE(substr,str,pos)
The first syntax returns the position of the first occurrence of substring
substr in
If surname is a field, then use it without the single quotes ('),
otherwise it is treated as a literal string and 0 is the correct result:
select locate(' ',surname,1) from advisers
andy thomas wrote:
Yes, this is the approach I was thinking of using but:
select locate('
On Tue, 8 Jun 2004, Vadim P. wrote:
If surname is a field, then use it without the single quotes ('),
otherwise it is treated as a literal string and 0 is the correct result:
select locate(' ',surname,1) from advisers
Thanks a lot, this is working. I now need to figure out how to use
Look at using the Reverse() function, then take the substring up to the
first space, then reverse the result.
Andy
-Original Message-
From: Paul McNeil [mailto:[EMAIL PROTECTED]
Sent: 08 June 2004 14:04
To: [EMAIL PROTECTED]
Subject: RE - Order By Problem
I have never done
PROTECTED]
Sent: 08 June 2004 14:04
To: [EMAIL PROTECTED]
Subject: RE - Order By Problem
I have never done anything like this but after looking at the spec's I
have
a possible direction for you
In String functions there is
LOCATE(substr,str,pos)
The first syntax returns
Andy,
Just:
select substring_index(surname,' ',-1) as r from advisers order by r;
works.
Andy
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]
Sent: 08 June 2004 15:57
To: Andy Eastham
Cc: Mysql List
Subject: RE: RE - Order By Problem
On Tue, 8 Jun 2004, Andy
work?
Thanks for your help,
Andy
-Original Message-
From: Paul McNeil [mailto:[EMAIL PROTECTED]
Sent: 08 June 2004 14:04
To: [EMAIL PROTECTED]
Subject: RE - Order By Problem
I have never done anything like this but after looking at the spec's I
have a possible direction for you
In String
Hi,
==
I have an ID field in my database...it reads like this
ASS1
ASS23
ASS4
ASS10
ASS6
when i'm retrieving the data by taking ORDER BY clause it is sorting like
this
ASS1
ASS10
ASS23
ASS4
ASS6
means its only sorting by the 4 the character. i want the sorting to be done
like the following
==
Martijn Tonies wrote:
Hi,
==
I have an ID field in my database...it reads like this
ASS1
ASS23
ASS4
ASS10
ASS6
when i'm retrieving the data by taking ORDER BY clause it is sorting like
this
ASS1
ASS10
ASS23
ASS4
ASS6
means its only sorting by the 4 the character. i want the sorting to be done
Sagar C Nannapaneni wrote:
ASS1
ASS23
ASS4
ASS10
ASS6
.
.
when i'm retrieving the data by taking ORDER BY clause it is sorting like this
ASS1
ASS10
ASS23
ASS4
ASS6
means its only sorting by the 4 the character.
No, it's not sorted by the first four characters but it's sorted
lexicographically
At 06:49 AM 1/23/2004, Sagar C Nannapaneni wrote:
Hi all,
I have an ID field in my database...it reads like this
ASS1
ASS23
ASS4
ASS10
ASS6
.
.
.
when i'm retrieving the data by taking ORDER BY clause it is sorting like this
ASS1
ASS10
ASS23
ASS4
ASS6
means its only sorting by the 4 the
The following might help, but will certainly be quite slow:
SELECT ... ORDER BY ABS(SUBSTRING(field, 4));
A better (and faster) solution will probably be indexing the records with
a numeric field, as usual.
Fred,
Doesn't MySQL always physically sort the rows and not use the
index to
At 20:43 +0100 2/16/03, sascha mantscheff wrote:
The following query works with mysql 3.23:
SELECT * FROM answer ORDER BY concat( n_sort, -, id_answer )
It does not with mysql 3.22.27. Neither does any query with a function call
in the order by clause. Is this documented somewhere? Am I missing
Am Sonntag, 16. Februar 2003 21:15 schrieb Paul DuBois:
At 20:43 +0100 2/16/03, sascha mantscheff wrote:
The following query works with mysql 3.23:
SELECT * FROM answer ORDER BY concat( n_sort, -, id_answer )
It does not with mysql 3.22.27. Neither does any query with a function
call in
assuming you have a table with two columns id and town
then here's one solution:
Create temporary table address (ad varchar(30));
Insert into address select concat(id, ' ', town)
from your_original_table_name;
select * from address order by ad;
--- Nicolas JOURDEN [EMAIL PROTECTED]
wrote:
[snip]
I'm having trouble with ordering. I've got data in a varchar field that
currently gets ordered like this when I use 'order by myfield asc':
aristo 1001
aristo 156
aristo 222
I'd like it to order like this:
aristo 156
aristo 222
aristo 1001
How can I do this in MySQL? Is there a way
On 11 Jul 2002, at 16:06, Dan Lamb wrote:
I'd like it to order like this:
aristo 156
aristo 222
aristo 1001
How can I do this in MySQL? Is there a way to take the numbers into
account when using order by?
There are various ways to break up your strings and convert part to a
number
* J.M. Roth [EMAIL PROTECTED] wrote on 28.01.01 02:05:
I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
module) on an Apache 1.3.12 (Linux).
...
$query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
doesn't work:
From your query I think you upgraded from a
"J.M. Roth" wrote:
Hello,
I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
module) on an Apache 1.3.12 (Linux).
Some SQL syntaxes that worked before don't anymore.
E.g.:
$query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
doesn't work:
29 matches
Mail list logo