Ordenação de números + texto

by gsguma

HTML

<script src="https://clipboardjs.com/dist/clipboard.min.js"></script>
<link rel="stylesheet" href="https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css">
<script src="https://netdna.bootstrapcdn.com/bootstrap/3.0.0/js/bootstrap.min.js"></script>
<script src="https://code.jquery.com/jquery-1.11.3.js"></script>
<strong>Mysql Query:</strong>
<textarea class="form-control" rows="9" id="txt">
SELECT 
	column_name 
FROM 
	table_name 
ORDER BY 
	column_name REGEXP '^\d*[^\da-z&amp;\.\' \-\"\!\@\#\$\%\^\*\(\)\;\:\<\>\,\?\/\~\`\|\_\-]' DESC
	,column_name + 0
	,column_name;
</textarea>
<button class="btn btn-primary" data-clipboard-action="copy" data-clipboard-target="#txt">
    Copy to clipboard
</button>

CSS

@import url('//netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap-theme.min.css');
body {
    margin: 10px;
}

.btn {
	margin-top: 5px;
}

JavaScript

jQuery(function(){
	new Clipboard('.btn');
});