Hi we need to order a field in a select query... The criteria is based on greek
language... The problem seems to be no support for greek language
I can change everything in the my.cnf so tell what to do
-
Do you Yahoo!?
vote.yahoo.com -
Hi all.
I have 2 problem about order by and date compare ??
1. I have two column
OrderDate date and OrderCode varchar(5)
the problem is if I use "select OrderCode,OrderDate from MyTable
order by OrderCode,OrderDate" the result come with error order it does
not display in correct order
Here are a couple of sample tables:
grants.grantidgrants.agency
1 NIH-F
2 NIH-F
3 NIH-F
dates.dateid dates.grantid dates.yearday
1 1 31
2 1 60
3 2
Hi,
On Wed, Mar 19, 2003 at 03:11:38PM -0800, Mike Lemke wrote:
> Hello MySQL Guru's-
> This is regarding UNION support in MySQL 4.0.12.
>
Never used it, but ...
> The query below is attempting to return rows that can
> be easily parsed for the purposes of creating XML.
> The ORDER BY is not
Hello MySQL Guru's-
This is regarding UNION support in MySQL 4.0.12.
The query below is attempting to return rows that can
be easily parsed for the purposes of creating XML.
The ORDER BY is not being processed properly at the
end of the query. Sample scripts are shown below, to
setup the DB and
turn them back into numbers with a math function
ORDER BY ABS(value)
> -Original Message-
> From: Jürgen Müller [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 5:23 PM
> To: [EMAIL PROTECTED]
> Subject: Add: Problem with ORDER BY
>
>
> I've cha
I've changed my query to:
$order = "SUBSTRING_INDEX(objektname,'-',1)";
$order .=
",RIGHT(objektname,(LENGTH(objektname)-LOCATE('-',objektname)))";
so that the syntax ist okay, and the tests too:
mySQL returns the correct values:
objekt SUBSTRING_INDEX(objekt,'-',1) LENGTH(objekt)
LOCATE('-'
I've changed my query to:
$order = "SUBSTRING_INDEX(objektname,'-',1)";
$order .=
",RIGHT(objektname,(LENGTH(objektname)-LOCATE('-',objektname)))";
so that the syntax ist okay, and the tests too:
mySQL returns the correct values:
objekt SUBSTRING_INDEX(objekt,'-',1) LENGTH(objekt)
LOCATE('-'
Hello,
I have a colum as varchar with entries like
MD1-1, SD1-10, MD1-4354, KD2-998, ...
Now I have a problem with sorting them, because they are treated as a
string (f.e. MD1-1 is bigger than KD-998).
My order query:
$order = "SUBSTRING_INDEX(b.objektname, '-', 1)"; // getting everithing
left