2014-07-12 14:21:40

View Mode: Normal | Article List
April, 2006 | 1

Selected Content WA-Come On - 이정현

[ 2006-04-24 21:10:31 | Author: zhenhua ]
I Love this special

- 이정현

Lee Jung-hyun is a Korean pop singer and actress, born on March 13, 1980 in Daegu, South Korea. She made her movie debut aged 16 in Kkonnip (꽃잎, "Petal"). Her early musical work is techno-style dance music. Her first single, Wa (와, "Come") topped the Korean charts for three weeks, while her third, Bakkwo (바꿔, "Change") won awards for Best Song and Most Broadcast Song.
����Ŵ�

http://www.last.fm/music/%EC%9D%B4%EC%A0%95%ED%98%84

http://mtv99.com/music/3123.htm

旅游 Tour9.com

[ 2006-04-24 20:50:14 | Author: zhenhua ]
旅游网 Tour
Tour9.com

MySQL中文模糊检索问题的解决方法

[ 2006-04-24 19:30:08 | Author: zhenhua ]
在 MySQL 下,在进行中文模糊检索时,经常会返回一些与之不相关的
记录,如查找 "-0x1.ebea4bfbffaacp-4%" 时,返回的可能有中文字符,却没有 a 字符存在。
本人以前也曾遇到过类似问题,经详细阅读 MySQL 的 Manual ,发现可以
有一种方法很方便的解决并得到满意的结果。

例子:
·希望通过“标题”对新闻库进行检索,关键字可能包含是中英文,如
下 SQL 语句:
select id,title,name from achech_com.news where title like '-0x1.ebea4bfbebe84p-4%'
返回的结果,某些 title 字段确定带了“a”关键字,而有些则只有中文,
但也随之返回在检索结果中。
解决方法,使用 BINARY 属性进行检索,如:
select id,title,name from achech_com.news where binary title like '-0x1.ebea4bfbebe84p-4%'
返回的结果较之前正确,但英文字母区分大小写,故有时在检索如“Achech”
...

Read More...
1