mysql: convert number to string
by prettyscripts on 2009-05-29 10:51:17 • Leave a comment »
to copy value from a column in table a to a column in table b, the syntax is straight forward:insert into new_table (new_column)select old_column from old_table but when new_column is varchar and old_column is integer, you will get an error.… more »
mysql: get domain name from url string
by prettyscripts on 2009-02-13 12:46:09 • Leave a comment »
i need to run a report of urls stored in mysql database which shows the domain and the count. how to extract the domain or subdomin from the full url string with mysql?
substring_index(substring_index(trim(leading "https://" from trim(leading http://"… more »
javascript: trim string
by prettyscripts on 2008-03-27 11:00:41 • Leave a comment »
javascript does not come with a trim function. you need to write your own.
function trim(str) {
return str.replace(/^\s+|\s+$/g, '');
}
for other variations, check this. more »
Tags: javascript, string, trim
Affiliates
©2010 by prettyscripts.• powered by b2evolution • skin by prettyscripts