The Blog

Author: admin

Change port 80 to 81 on Wampserver

Posted on

I assume your server Configuration:
Apache Version: 2.2.
PHP Version:   5.2.6

Now that you have WampServer 2.0 installed, you’ll want to use it along side   with other servers such as IIS. This is easily done by changing the port that   WampServer 2.0 listens to. I suggest changing the port from 80 to 81.
Read More

Posted in MySQL, PHP 8 Comments

Find longest string in a column MySQL

Posted on
select name from daTable
where length(name) =
( select max(length(name)) from daTable )

How about the record that has the most number of words ? I am referring to MYSQL manual now, but still can’t find a solution for this.

SELECT lemma FROM word 
WHERE (LENGTH(lemma)-LENGTH(REPLACE(lemma,' ',''))) = 
(SELECT MAX(LENGTH(lemma)-LENGTH(REPLACE(lemma,' ',''))) FROM word);
Posted in MySQL Leave a comment
« Previous PageNext Page »