nano /etc/sysconfig/i18n

At the last line, add

LC_ALL=en_US.UTF-8

Done!

1) Open Terminal

2) To hide the hidden files, key in the below:

defaults write com.apple.finder AppleShowAllFiles TRUE

killall Finder

3) To display the hidden files, key in the below:

defaults write com.apple.finder AppleShowAllFiles FALSE

killall Finder

MySQL by default requires minimum of 4 alphabets to perform a search.

Here is a way to modify the minimum number on CentOS:

# mysql -u root

# nano /etc/my.cnf

add the below line and save it, the number indicate the minimum length for the search, here we put 3.

ft_min_word_len=3

# service mysqld restart

rebuild the fulltext index of sql and it should work.

About this idea, you won't usually think about it until you really need it. Here is an example where you need it:
Assume you have a `table` with primary key `id` and you have `id` value 1 to 10000 stored in that table. When you are going up adds every `id` by 1, you may write

update `table` set `id`