Strict Standards: Non-static method Advanced_Permalinks::get() should not be called statically in /blog/wp-content/plugins/advanced-permalinks/advanced-permalinks.php on line 825

Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method GoogleSitemapGeneratorLoader::Enable() should not be called statically in /blog/wp-includes/plugin.php on line 123

Warning: call_user_func_array() expects parameter 2 to be array, null given in /blog/wp-includes/plugin.php on line 123
[MYSQL] Jak posortować rekordy wg ilości znaków w polu? » Porady MySQL » egrafik.pl
BAZA WIEDZY
KURSY
Bazy danych w PHP
Kurs AdvancedAJAX
Kurs ASP
Kurs ASP.NET
Kurs C++
Kurs CSS
Kurs HTML
Kurs HTML drugi
Kurs JavaScript
Kurs MySQL
Kurs PHP
Kurs RSS
Kurs XHTML
Obiekty DOM
MANUALE
CSS1 - W3C
DOM - w budowie
PHP 2005
PHP 2006
Wyrażenia regularne
SHOUTBOX
STAT
Online: 29 | UU: 634

Strict Standards: Resource ID#196 used as offset, casting to integer (196) in /forum2/db/mysql4.php on line 223

Strict Standards: Resource ID#196 used as offset, casting to integer (196) in /forum2/db/mysql4.php on line 224
[MYSQL] Jak posortować rekordy wg ilości znaków w polu?
Porady MySQL | 5 maj 2008 | Wizyt: 104537

Strict Standards: Only variables should be assigned by reference in /blog/wp-includes/post.php on line 114

Strict Standards: Only variables should be assigned by reference in /blog/wp-includes/post.php on line 114

Strict Standards: Only variables should be assigned by reference in /blog/wp-includes/post.php on line 114

Strict Standards: Only variables should be assigned by reference in /blog/wp-includes/post.php on line 114

Strict Standards: Only variables should be assigned by reference in /blog/wp-includes/post.php on line 114

Strict Standards: Only variables should be assigned by reference in /blog/wp-includes/post.php on line 114

Deprecated: Function eregi() is deprecated in /blog/wp-content/plugins/tpbc.php on line 96

Czasem zachodzi potrzeba posortowania tabeli według długości danych tekstowych w wybranej kolumnie. Taki przypadek może nastąpić przykładowo w sytuacji, gdy chcemy wyświetlić artykuły posortowane wg obszerności treści jaką zawierają. Jest na to rozwiązanie.

Przykład:

Kod: mysql

SELECT * FROM tabela ORDER BY LENGTH(nazwa_kolumny)
 

Opracowanie: Adam Suchowski

nowe Porady MySQL » zobacz wszystkie
Dodaj komentarz









Komentarze
Jeden komentarz
2 styczeń 2017, godz. 7:02

Write more, thats all I have to say.Literally, it seems
as thouggh you relied on the video to make your point.
You clearly know what youre talking about, why throw away your intelligence on just posting videos to your blog when you coukd be giving uus something enlightening to read?

 
| | | |
Copyright © 2006-2013 egrafik.pl | Kontakt | Reklama | Projekty domów
jocker