On Wed, May 21, 2014 at 4:50 AM, Hartmut Holzgraefe wrote:
> On 05/21/2014 08:14 AM, Johan De Meersman wrote:
>
>>> ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE
>>> latin1_general_ci;
>>
>> Purely from memory, doesn't that change the table but add the old setting to
>> individual t
Am 21.05.2014 10:50, schrieb Hartmut Holzgraefe:
> On 05/21/2014 08:14 AM, Johan De Meersman wrote:
>
>>> ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE
>>> latin1_general_ci;
>>
>> Purely from memory, doesn't that change the table but add the old setting to
>> individual text colum
On 05/21/2014 08:14 AM, Johan De Meersman wrote:
>> ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE
>> latin1_general_ci;
>
> Purely from memory, doesn't that change the table but add the old setting to
> individual text columns?
right, the above will only change the default for new
- Original Message -
> From: "Reindl Harald"
> Subject: Re: Case sensitivity
>
> ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE
> latin1_general_ci;
Purely from memory, doesn't that change the table but add the old setting to
individual t
Am 21.05.2014 00:48, schrieb Larry Martell:
>> ok, in this case the interesting piece of information
>> would be the "SHOW CREATE TABLE pnlCurrency;" output
>> from both.
>>
>> As the collation_database variables differ between the
>> two servers ("utf8_bin" vs. "latin1_swedish_ci") I assume
>> t
On Tue, May 20, 2014 at 5:52 PM, Hartmut Holzgraefe wrote:
> On 05/20/2014 11:10 PM, Larry Martell wrote:
>
>> 5.5 server:
>>
>> mysql> select distinct(pnlCurrency) from PnLDetail;
>> +-+
>> | pnlCurrency |
>> +-+
>> | USD |
>> | USd |
>> +-+
>>
On 05/20/2014 11:10 PM, Larry Martell wrote:
> 5.5 server:
>
> mysql> select distinct(pnlCurrency) from PnLDetail;
> +-+
> | pnlCurrency |
> +-+
> | USD |
> | USd |
> +-+
> 2 rows in set (0.00 sec)
>
> 5.0 server:
>
> mysql> select distinct(pn
On Tue, May 20, 2014 at 9:38 AM, Hartmut Holzgraefe wrote:
> On 05/20/2014 03:26 PM, Larry Martell wrote:
>> Yet the 5.5.25a server is case sensitive as you would expect, but the
>> 5.0.77 is not. How can I make the 5.0.77 server case sensitive?
>>
>
> please provide the output of
>
> SHOW VARIA
On 05/20/2014 03:26 PM, Larry Martell wrote:
> Yet the 5.5.25a server is case sensitive as you would expect, but the
> 5.0.77 is not. How can I make the 5.0.77 server case sensitive?
>
please provide the output of
SHOW VARIABLES LIKE 'character_set_%';
and
SHOW VARIABLES LIKE 'collation_%'
Am 20.05.2014 15:26, schrieb Larry Martell:
> I have 2 servers, one is running 5.5.25a and the other 5.0.77.
>
> They both have the same collation and character set:
>
> mysql> SELECT COLLATION(VERSION());
> +--+
> | COLLATION(VERSION()) |
> +--+
> | utf8_
I have 2 servers, one is running 5.5.25a and the other 5.0.77.
They both have the same collation and character set:
mysql> SELECT COLLATION(VERSION());
+--+
| COLLATION(VERSION()) |
+--+
| utf8_general_ci |
+--+
1 row in set (0.00 s
n any
platform, nor are column aliases.
Can we see your query?
Regards
Adrian
- Original Message -
From: Scott Haneda
To: Adrian Aitken
Cc: mysql@lists.mysql.com
Sent: Thursday, August 27, 2009 11:04 PM
Subject: Re: Getting mySQL to ignore case sensitivity of field names
htt
Oops, sorry about that. My understanding is this is OS dependent:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
You may be able to set lowercase tables names, but would always have
to use lowercase. I would just stick to entering in the correct case,
as the other m
o only talk about field values.
Regards
Adrian
- Original Message -
From: Scott Haneda
To: Adrian Aitken
Cc: mysql@lists.mysql.com
Sent: Thursday, August 27, 2009 11:04 PM
Subject: Re: Getting mySQL to ignore case sensitivity of field names
http://dev.mysql.com/doc/refman/5.0/en/case-se
http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
You need to set the field format to a non binary one, and case
insensitive will be the default.
On Aug 27, 2009, at 2:57 PM, Adrian Aitken wrote:
Hi, Google isn't my friend :-(
How can I tell mySQL 5.0 to ignore the case of field n
Hi, Google isn't my friend :-(
How can I tell mySQL 5.0 to ignore the case of field names i.e. FullName
should also be able to be referenced as fullname,fullNAME etc ?
I'm running it on a linux box at home but my copy at work (running on
Windows 2000 server) has this by default - I certainly set
Could someone explain the logic of how case sensivity works on stored
procedure formal argument names?
Example:
CREATE PROCEDURE sp_Test ( IN col1 INT,
IN col2 INT )
BEGIN
INSERT INTO Table
SET COL1 = col1,
COL2 = col2;
END
We've found that this is problem
At 16:01 -0600 3/16/06, Sterling Anderson wrote:
On Mar 16, 2006, at 3:49 PM, Paul DuBois wrote:
This fails however. 'g/dl' != 'g/dL' though. I don't get why a
string field is being treated this way. I understand the HFS+
filesystem is not case sensitive but that shouldn't be an issued
with v
On Mar 16, 2006, at 3:49 PM, Paul DuBois wrote:
This fails however. 'g/dl' != 'g/dL' though. I don't get why a
string field is being treated this way. I understand the HFS+
filesystem is not case sensitive but that shouldn't be an issued
with varchar fields should it?
No, it's not a file
At 15:22 -0600 3/16/06, Sterling Anderson wrote:
I'm running MySQL 5.0.18 on OS X 10.4.5, on an intel MacBook. My
table definition is:
CREATE TABLE `UNIT` (
`UNIT_ID` int(11) NOT NULL auto_increment,
`UNIT_CODE` varchar(50) default NULL,
`UNIT_DESC` varchar(50) default NULL,
`USER_ID` i
I'm running MySQL 5.0.18 on OS X 10.4.5, on an intel MacBook. My
table definition is:
CREATE TABLE `UNIT` (
`UNIT_ID` int(11) NOT NULL auto_increment,
`UNIT_CODE` varchar(50) default NULL,
`UNIT_DESC` varchar(50) default NULL,
`USER_ID` int(11) NOT NULL,
`USER_DT` datetime NOT NULL,
RE BINARY text LIKE '%Jehovah%'
>
> On Nov 8, 2005, at 9:15 AM, Scott Hamm wrote:
>
> > I am running MySQL 5.0.15-nt on Windows 2000 PRO and use PHP as
> > front-end for word search in Bible. My goal is to set an option for
> > case sensitivity in text sear
vah%'
On Nov 8, 2005, at 9:15 AM, Scott Hamm wrote:
I am running MySQL 5.0.15-nt on Windows 2000 PRO and use PHP as
front-end for word search in Bible. My goal is to set an option for
case sensitivity in text search. For example, if I want to search for
the word "Jehovah*" I wou
I am running MySQL 5.0.15-nt on Windows 2000 PRO and use PHP as
front-end for word search in Bible. My goal is to set an option for
case sensitivity in text search. For example, if I want to search for
the word "Jehovah*" I would expect "Jehovah" not "JEHOVAH". Thi
Le dim 05/09/2004 à 00:14, Yannick Warnier a écrit :
> Hi,
>
> When I execute a query in MySQL client, it seems like I cannot get the
> case-sensitivity to be activated.
>
> If I ask:
> SELECT * FROM mytable WHERE field = 'd';
>
> I get all records contai
You need BINARY <http://dev.mysql.com/doc/mysql/en/Cast_Functions.html>.
SELECT * FROM mytable WHERE BINARY field = 'd';
Michael
Yannick Warnier wrote:
Hi,
When I execute a query in MySQL client, it seems like I cannot get the
case-sensitivity to be activated.
If I ask:
SELEC
Hi,
When I execute a query in MySQL client, it seems like I cannot get the
case-sensitivity to be activated.
If I ask:
SELECT * FROM mytable WHERE field = 'd';
I get all records containing 'd' or 'D'.
How do I enable case-sensitivity?
Thanks,
Yannick
--
MySQL
On Mon, 2004-02-23 at 08:56, Tim Hayes wrote:
> OK
>
> There is still the possibility of an in-compatability between the 2
> platforms.
>
> However - in both Linux and Windows (MySQL 4.0.17) the variable is not
> recognized / updateable using the set command!
>
>
> I get - Unknown system variab
At 16:56 + 2/23/04, Tim Hayes wrote:
OK
There is still the possibility of an in-compatability between the 2
platforms.
However - in both Linux and Windows (MySQL 4.0.17) the variable is not
recognized / updateable using the set command!
Correct. You must set it using an option at server start
Table Name Case Sensitivity
OK
There is still the possibility of an in-compatability between the 2
platforms.
However - in both Linux and Windows (MySQL 4.0.17) the variable is not
recognized / updateable using the set command!
I get - Unknown system variable 'lower_case_table_na
al Message -
From: "Peter Zaitsev" <[EMAIL PROTECTED]>
To: "Tim Hayes" <[EMAIL PROTECTED]>
Sent: Monday, February 23, 2004 4:19 PM
Subject: Re: Table Name Case Sensitivity
> On Mon, 2004-02-23 at 08:15, Tim Hayes wrote:
> > Can anyone offer advice?
>
ecause they are directories, but not to column names because they
are concealed inside the data files.
There is no right answer to the question of case sensitivity. Mostly it
will depend from which direction you approach the problem. As someone who
uses both Windows and Linux, I can put on a dif
Tim Hayes said:
> Can anyone offer advice?
>
> I have come across a MySQL database on Linux with duplicate table
> names - "Accounts" and "accounts". This seems fine on Linux, but
> does not transfer to the Windows environment - it is rejected
> because of the duplicate name. However I do see that
Can anyone offer advice?
I have come across a MySQL database on Linux with duplicate table names - "Accounts"
and "accounts". This seems fine on Linux, but does not transfer to the Windows
environment - it is rejected because of the duplicate name. However I do see that
Column Names have to be
At 13:00 -0500 12/17/03, Mayuran Yogarajah wrote:
Paul DuBois wrote:
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT *
Paul DuBois wrote:
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table n
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table name is still MyTest
b
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table name is still MyTest
but selects work with mytest ?
--
MySQL General M
At 17:51 -0500 3/2/03, Sunfire wrote:
hi i have a delete query that will delete a record based on the company
name:
delete from members where company='$company';
the query works fine and all but there is a problem because if there is more
than 1 company listed but with different use of case in thei
hi i have a delete query that will delete a record based on the company
name:
delete from members where company='$company';
the query works fine and all but there is a problem because if there is more
than 1 company listed but with different use of case in their name then
allrecords that match $com
You can specify a varchar field as binary, for instance: field1 varchar(50)
binary
query, sql
Mike
-Original Message-
From: asp52 [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:50 AM
To: Mike Grabski; [EMAIL PROTECTED]
Subject: Re: Case sensitivity
Thanks,
Just worked
searching tables based on search values which turn up tobe
fine,
however the results dont reflect case sensitivity.
what i mean,
if i run following query
select field1 from table1 where name='text1';
this works fine but returns the same result set with text1 values of 'USER'
or &#
>
To: "'asp52'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, December 19, 2002 2:29 PM
Subject: RE: Case sensitivity
> You have two choices, you can use a binary datatype for the field, or
force
> a binary comparison usin
:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:06 AM
To: [EMAIL PROTECTED]
Subject: Case sensitivity
Hi,
I have been searching tables based on search values which turn up tobe fine,
however the results dont reflect case sensitivity.
what i mean,
if i run following query
select field1
Hi,
I have been searching tables based on search values which turn up tobe fine,
however the results dont reflect case sensitivity.
what i mean,
if i run following query
select field1 from table1 where name='text1';
this works fine but returns the same result set with text1 values of
Mark:
Do you have my.ini (or my.cfg) set to ignore case in table names?
set-variable = lower_case_table_names=1
Gerald Jensen
- Original Message -
From: "Mark Weiler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 5:56 PM
Subject: Case
Mac OS X
mysql 3.23.47
I have a database with a table named: tname.
After several inserts, I run
CHECK TABLE tname;
No errors are reported.
I then run
CHECK TABLE TNAME;
And errors are reported!
Which is it? Errors or no errors?
Thanks
Mark
-
On 22 May 2002, at 14:52, Richard Bolen wrote:
> Is there any way via a SQL query to force case sensitivity to be
> used for a non-binary char field? i.e.: for comparing strings in a
> case sensitive way.
SELECT * FROM users WHERE BINARY password = 'cAsE_MAttErS';
http://ww
table if exists foo2;
> create table foo2(
> pk1 integer NOT NULL,
> fk1 integer,
> foreign key (fk1) references FOO1 (pk1),
> index ix1 (fk1)
> ) type = innodb;
>
>
> >Fix:
>
>
> >Submitter-Id:
> >Originator: Eugene Bekker
> >
Hi Richard,
Richard Bolen wrote:
>If I understand correctly, you have to define a char field as binary if you want the
>database to treat it as a 'case sensitive' field. Is there any way via a SQL query
>to force case sensitivity to be used for a non-binary char field? i.
If I understand correctly, you have to define a char field as binary if you want the
database to treat it as a 'case sensitive' field. Is there any way via a SQL query to
force case sensitivity to be used for a non-binary char field? i.e.: for comparing
strings in a case sensitiv
foo2;
create table foo2(
pk1 integer NOT NULL,
fk1 integer,
foreign key (fk1) references FOO1 (pk1),
index ix1 (fk1)
) type = innodb;
>Fix:
>Submitter-Id:
>Originator:Eugene Bekker
>Organization:
>MySQL support: none
>Synopsi
At 11:03 3/4/2002 -0500, Eugene Mah wrote:
Hi!
Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.
C:\>c:\mysql\bin\mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.49-ma
I seem to be having issues with the way MySQL names
the table files under Unix and WinXP. I'm not sure if it's a
mysql issue or a windows issue.
Normally, when I create tables in MySQL, I like to capitalize the
first letter. Under unix, it all works fine and dandy. But under
WinXP, the table n
At 11:17 AM 3/14/2002, you wrote:
>On Thursday 14 March 2002 9:32 am, BD wrote:
> >
> > Why or why couldn't MySQL have used case insensitive names in the first
> > place? Store everything in lower case internally, but allow the user to use
> > "Invoice_Number" or "invoice_number" or "INVOICE_NUMBE
On Thursday 14 March 2002 9:32 am, BD wrote:
>
> Why or why couldn't MySQL have used case insensitive names in the first
> place? Store everything in lower case internally, but allow the user to use
> "Invoice_Number" or "invoice_number" or "INVOICE_NUMBER" in the SQL
> statement and it should ref
At 02:05 AM 3/14/2002, you wrote:
>Hi,
>I run mysql on windows as well as linux.
>table creation and access right are given by java program.
>
>Problem im facing is.,
>i create a table with name TEMP
>in windows in creates table with name "temp" and linux "TEMP"
>while giving rights thru GRANTst
Hi,
I run mysql on windows as well as linux.
table creation and access right are given by java program.
Problem im facing is.,
i create a table with name TEMP
in windows in creates table with name "temp" and linux "TEMP"
while giving rights thru GRANTstatement , it fails in windows cause it
exp
var1)
>
> It works great except that the search is coming out case sensitive.
> According to the MySQL Docs all searches are done without case
> sensitivity.
Well, not completely. The default is case insensitivity, but depending
on the context, you get case sensitive comparisons. See a
o the MySQL Docs all searches are done without case
sensitivity.
I just have 2 questions:
1) I think the syntax I'm using is correct but incase it's not what is
the correct syntax for a case insensitive search?
2) What version of MySQL did the default of case insensitive searches
begin as I&
>Description:
>How-To-Repeat:
>Fix:
THANX
>Submitter-Id: <[EMAIL PROTECTED]>
>Originator: root
>Organization:
>MySQL support: [none ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-4.0.1-alpha (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.18 Di
rom: Mr Kent Cheung <[EMAIL PROTECTED]>
> Subject: Table names case sensitivity
> To: MySQL Discussion <[EMAIL PROTECTED]>
>
> Dear MySQL community,
>
> I am new MySQL user. I want to migrate a M$ SQL
> Server
> database to MySQL in a Linux box. Since table names
&
have grants on database.Company instead of database.company
You should update permissions for you.
MKC> Thanks for your suggestion anyway.
MKC> Kent.
[skip]
>>
>> MKC> I search the documentation and find that I may
>> be able
>> MKC> to disable the case
u, 31 Jan 2002 12:12:01 +0200
> To: [EMAIL PROTECTED]
> From: Egor Egorov <[EMAIL PROTECTED]>
> Subject: Table names case sensitivity
>
> Mr,
>
> Thursday, January 31, 2002, 6:01:21 AM, you wrote:
> MKC> Dear MySQL community,
>
> MKC> I am new MySQL user. I w
the server via ODBC from a Windows box.
MKC> I search the documentation and find that I may be able
MKC> to disable the case sensitivity by setting the
MKC> variable called lower_case_table_names to 1 when
MKC> starting the server. I edit my.cnf and restart the
MKC> server. Everythin
Neil,
Thank you for your suggestion. Unfortunately, the
Grant command grants privileges to lower case table
names also. I have also tried to find solution from
archive of mysql mail lists but nothing useful have
been found.
Kent.
--- Neil Silvester
<[EMAIL PROTECTED]>
wrote:
> > -Original
disable the case sensitivity by setting the
variable called lower_case_table_names to 1 when
starting the server. I edit my.cnf and restart the
server. Everything seems OK. mysqladmin and the Show
Variables command in mysql confirm that this variable
is now 1 instead of 0 before I make the changes
At 16:22 10/01/2002, you wrote:
>On Thu, Jan 10, 2002 at 12:58:03PM -0200, Fernando Monteiro Duarte wrote:
> >
> > But how about the fields, the content of a database ??
>
>VARCHAR and CHAR fields are not case-sensitive unless you declare them
>with the BINARY attribute.
neither TEXT/LONGTEXT
* Fernando Monteiro Duarte
> But how about the fields, the content of a database ??
char and varchar are by default not case sensitive, but can be made case
sensitive using the BINARY operator...
http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html >
--
Roger
On Thu, Jan 10, 2002 at 12:58:03PM -0200, Fernando Monteiro Duarte wrote:
>
> But how about the fields, the content of a database ??
VARCHAR and CHAR fields are not case-sensitive unless you declare them
with the BINARY attribute.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yaho
> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Subject: Re: Disable case sensitivity
> > If is possible, in everything from a Database, but if
> is not, in columns
> > is more important.
>
> Column names are case insensitiv
But how about the fields, the content of a database ??
Fernando
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 12:32 PM
Subject: Re: Disable c
On Thu, Jan 10, 2002 at 09:14:51AM -0500, Ho, Kam wrote:
>
> Can you specify the hardware/software your MySQL 3.23.41-max is
> running on?
That machine is a dual-CPU Linux 2.4.9 box with 2GB of RAM and 4 36GB
ultra-wide SCSI drives for the data and replication logs.
Before the restart we did in
Fernando Monteiro Duarte writes:
> Hi Mr. Zawodny,
>
> If is possible, in everything from a Database, but if is not, in columns
> is more important.
>
> Thanks in advance,
> Fernando Monteiro Duarte
Hi!
Column names are case insensitive.
--
Regards,
__ ___ ___ _
Jerry:
Can you specify the hardware/software your MySQL 3.23.41-max is running on?
Kam
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 9:07 AM
To: Fernando Monteiro Duarte
Cc: [EMAIL PROTECTED]
Subject: Re: Disable case sensitivity
ot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 12:06 PM
Subject: Re: Disable case sensitivity
> On Thu, Jan 10, 2002 at 11:52:34AM -0300, Fernando Monteiro Duarte wrote:
> > Hi,
> >
> > Does anybody knows if is possibl
On Thu, Jan 10, 2002 at 11:52:34AM -0300, Fernando Monteiro Duarte wrote:
> Hi,
>
> Does anybody knows if is possible to disable case sensitivity in
> Linux MySQL??
Case sensitivity in what part? Table names? Values in columns?
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]&g
Hi,
Does anybody knows if is possible to disable case sensitivity in Linux
MySQL??
Thanks in advance,
Fernando Monteiro Duarte
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hi,
I have a situation as follows:
There is a table that stores the user name.
One user name is 'David' and another is 'david'
I want to select only the user with the name
'david'(all small and not 'David')
MySQL is case insensitive in selecting records...
how to make it case-sensitive in selec
Since Mac OS X is Unix it should use the same rules as a Unix machine
when it comes to MySQL and case sensitivity of table and database
names. According to Dubois: "DB and tables in MySQL correspond to
directories and files in the underlying file system on the server
host. As a result,
> I'm having trouble with what appears to be a case sensitivity issue.
> Essentially, when I use the "right" case for a table name, the query fails,
> but when I use the wrong case, the query succeeds.
Well, it seems to depend on the system you are using. I noticed
th
I'm having trouble with what appears to be a case sensitivity issue.
Essentially, when I use the "right" case for a table name, the query fails,
but when I use the wrong case, the query succeeds.
Here's my table list:
mysql> show tables\g
+-
Select Name, lower(name) as sortOrder from users order by sortOrder;
Not exactly what you wanted, but closer.
Cal
http://www.calevans.com
-Original Message-
From: Kif Henderson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 7:38 PM
To: [EMAIL PROTECTED]
Subject: Case
Hi,
Can somebody PLEASE help me
If I send a query to get a list of names, like this:
SELECT Name FROM users ORDER BY Name,
I get a list of users like this...
Bob
Jon
Mark
Sally
andy
lucy
mary
steve
when what I REALLY want is this...
andy
Bob
Jon
lucy
Mark
mary
Sally
Steve
Can someone g
84 matches
Mail list logo
