How To Sort Text as a Number in MySQL

Author: , July 11th, 2013

select theField from theTable order by theField+0; ~OR~ select theField from theTable order by CAST(theField AS UNSIGNED);

How To Convert HTML Entity Codes To Plain Text

Author: , April 10th, 2012

Using Perl: use HTML::Entities; my $plainText = decode_entities(‘Put text to convert here’); Using PHP: $plainText = html_entity_decode(‘Put text to convert here’,ENT_QUOTES,’UTF-8′);