July 1, 2008 at 10:36 pm
· Filed under MySQL
It is a common requirement to count number of words in a column of a MySQL database table. But MySQL does not have any built in function to count number of words as it usually has for number of purposes.
But you can do it without it with a simple trick e.g. you have a column name and want to count number of words in it. This query will return number of words separated with space in a column
SELECT SUM( LENGTH(name) - LENGTH(REPLACE(name, ' ', ''))+1)
FROM table
If you want to count number of words separated by some other string for example comma (,) or semicolon (;), simply replace space with your required character.
Permalink
May 1, 2008 at 3:31 pm
· Filed under MySQL
I am creating a list of MySQL GUI tools. I hope you will contribute this list.
A wide variety of MySQL GUI tools are available in the market. Most of them are free but some are paid as well. We can divide GUIs in 2 categories i.e. desktop and web based applications. Here is the list of popular MySQL GUI tools I have heard of
- Desktop Application
- Web Based Application
If you know any good GUI Tool, please let me know.
Permalink
July 18, 2007 at 11:33 pm
· Filed under MySQL, PHP
People have different opinions on saving images in database. Some says, "Why bother database if we can handle this by saving images to disk". I am agree with this;).
Most of the requirements can be fulfilled by saving the images to disk. This reduces the unnecessary load on MySQL.
Here is the small code to save the image in MySQL with the help of PHP.
Read the rest of this entry »
Permalink
July 1, 2007 at 4:05 am
· Filed under MySQL, PHP
This is a very simple example to download data in csv format using PHP and MySQL. I have used a table with two columns i.e. id and name.
The main point to download file is a proper use of header(). It has said many times in many places but I repeat here, "Make sure there must not be any sort of output (including whitespaces) before header()". We can also set a default file name for the file.
Here is the PHP code
Read the rest of this entry »
Permalink