OpenForum RSS: ��

�� (Jaivan)

Wed, 11 Mar 2009 11:46:49 GMT

>�� order by prefix desc limit 1

�� )))
��, �� :
SELECT c.dt,
c.klient,
c.tel1,
b.country,
b.countryid,
b.costout,
ROUND(c.dur, 0) AS dur,
ROUND((c.dur/60*b.costout), 5) AS Summa
FROM
bil b
INNER JOIN cdr c ON c.tel1 LIKE CONCAT(b.countryid, '%')
LEFT JOIN bil bi ON
bi.countryid != b.countryid
AND LENGTH(bi.countryid) > LENGTH(b.countryid)
AND c.tel1 LIKE CONCAT(bi.countryid, '%')
WHERE bi.countryid IS NULL
ORDER BY c.dt

�� ROUND(c.dur, 0) AS dur � ROUND((c.dur/60*b.costout), 5) AS Summa
�� ?

�� (other)

Fri, 06 Mar 2009 07:20:37 GMT

�� order by prefix desc limit 1

�� (Jaivan)

Fri, 06 Mar 2009 07:10:23 GMT

>[�� ]
>1 row in set (0.00 sec)
>
>mysql> select * from test where left('123488977324324212', length(prefix)) = prefix order by prefix desc limit 1;
>+----+--------+
>| id | prefix |
>+----+--------+
>| 4 | 1234 |
>+----+--------+
>1 row in set (0.00 sec)
>[/code]

�� :
WHERE CAST(field1 AS CHAR) LIKE CONCAT(CAST(field2 AS CHAR), '%')
�� :
WHERE LEFT(tel1, length(countryid)) = countryid
�� , �� , ��

�� (other)

Thu, 05 Mar 2009 20:21:22 GMT

[code]
mysql> select * from test;
+----+--------+
| id | prefix |
+----+--------+
| 1 | 1 |
| 2 | 12 |
| 3 | 123 |
| 4 | 1234 |
| 5 | 12345 |
+----+--------+
5 rows in set (0.00 sec)

mysql> select * from test where left('1288977324324212', length(prefix)) = prefix order by prefix desc limit 1;
+----+--------+
| id | prefix |
+----+--------+
| 2 | 12 |
+----+--------+
1 row in set (0.00 sec)

mysql> select * from test where left('12388977324324212', length(prefix)) = prefix order by prefix desc limit 1;
+----+--------+
| id | prefix |
+----+--------+
| 3 | 123 |
+----+--------+
1 row in set (0.00 sec)

mysql> select * from test where left('123488977324324212', length(prefix)) = prefix order by prefix desc limit 1;
+----+--------+
| id | prefix |
+----+--------+
| 4 | 1

OpenForum RSS: �������� � ��������

�������� � �������� (Jaivan)

�������� � �������� (other)

�������� � �������� (Jaivan)

�������� � �������� (other)

OpenForum RSS: ��

�� (Jaivan)

�� (other)

�� (Jaivan)

�� (other)