OpenForum RSS: �� SELECT �� order �� varchar �� ....

�� SELECT �� order �� varchar �� .... (angra)

Thu, 15 Jan 2009 23:43:50 GMT

� �� , ��. � �� . �� , � �� .

�� SELECT �� order �� varchar �� .... (MiF)

Thu, 15 Jan 2009 08:59:32 GMT

��! :) ��, �� .

�� SELECT �� order �� varchar �� .... (other)

Thu, 15 Jan 2009 08:15:12 GMT

mysql> CREATE TABLE auto (
-> num VARCHAR(10) DEFAULT NULL
-> )ENGINE=MyISAM;

Query OK, 0 rows affected (0.02 sec)

mysql>
mysql> insert into auto values('x111xx177');
Query OK, 1 row affected (0.00 sec)

mysql> insert into auto values('aj45hn67nn');
Query OK, 1 row affected (0.00 sec)

mysql> insert into auto values('sfde45njh5');
Query OK, 1 row affected (0.00 sec)

mysql> insert into auto values('5fv67yy78u');
Query OK, 1 row affected (0.00 sec)

mysql> insert into auto values('aaas23dsdd');
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> delimiter //
mysql> CREATE DEFINER = CURRENT_USER FUNCTION `digital`(param1 varchar(10))
-> RETURNS varchar(10)
-> NOT DETERMINISTIC
-> CONTAINS SQL
-> SQL SECURITY DEFINER
-> COMMENT ''
-> begin
-> declare a int default 1;
-> declare b int default 0;
-> declare c int default 0;
-> declare d varchar(10) default '';
-> set b = length(param1);

�� SELECT �� order �� varchar �� .... (MiF)

Wed, 14 Jan 2009 20:37:25 GMT

>[�� ]
>>�� , � �� . ��
>>varchar(10) �� : "x111xx177".
>>
>>��
>>��.
>>
>>�� , �� -�� . ��
>>�� , �� :)
>
>SELECT CONCAT(SUBSTRING(auto_nomer,2,3),SUBSTRING(auto_nomer,7,3)) as digital_nomer ORDER BY digital_nomer

��, �� . �� , �� , �� , �� . �� , �� . �� -�� , �� ? TRIM �� , �� , �� 0-9?

�� SELECT �� order �� varchar �� .... (Andrew4fr)

Wed, 14 Jan 2009 20:09:05 GMT

>��. �� , �� .
>
>�� , � �� . ��
>varchar(10) �� : "x111xx177".
>
>��
>��.
>
>�� , �� -�� . ��
>�� , �� :)

SELECT CONCAT(SUBSTRING(auto_nomer,2,3),SUBSTRING(auto_nomer,7,3)) as digital_nomer ORDER BY digital_nomer

OpenForum RSS: ��� � SELECT ������� order �� varchar �� ....

��� � SELECT ������� order �� varchar �� .... (angra)

��� � SELECT ������� order �� varchar �� .... (MiF)

��� � SELECT ������� order �� varchar �� .... (other)

��� � SELECT ������� order �� varchar �� .... (MiF)

��� � SELECT ������� order �� varchar �� .... (Andrew4fr)

OpenForum RSS: �� SELECT �� order �� varchar �� ....

�� SELECT �� order �� varchar �� .... (angra)

�� SELECT �� order �� varchar �� .... (MiF)

�� SELECT �� order �� varchar �� .... (other)

�� SELECT �� order �� varchar �� .... (MiF)

�� SELECT �� order �� varchar �� .... (Andrew4fr)