2.1w+
社区成员
- 主页
去掉mysql查询字段的空格问题
SELECT league.ChineseName, xc_match.match_id
FROM league
LEFT JOIN xc_match ON ( league.ChineseName = str_replace(
' ', '', xc_match.match_name
) ) LIMIT 0 , 30
举例：ChineseName是 ‘中国’ match_name 就是 ‘中 国’
这问题着急 望指点
FROM league
LEFT JOIN xc_match ON ( league.ChineseName = str_replace(
' ', '', xc_match.match_name
) ) LIMIT 0 , 30
举例：ChineseName是 ‘中国’ match_name 就是 ‘中 国’
这问题着急 望指点
...全文
请发表友善的回复…
发表回复
Dleno 2010-08-05
[Quote=引用 1 楼 amani11 的回复:]
REPLACE(xc_match.match_name, ' ', '')
[/Quote]
+++
接上，哈哈
REPLACE(xc_match.match_name, ' ', '')
[/Quote]
+++
接上，哈哈
gumwzg 2010-08-05
[Quote=引用 1 楼 amani11 的回复:]
REPLACE(xc_match.match_name, ' ', '')
[/Quote]
++
REPLACE(xc_match.match_name, ' ', '')
[/Quote]
++
kyzy_yy_pm 2010-08-05
[Quote=引用 1 楼 amani11 的回复:]
REPLACE(xc_match.match_name, ' ', '')
[/Quote]+
REPLACE(xc_match.match_name, ' ', '')
[/Quote]+
amani11 2010-08-05
REPLACE(xc_match.match_name, ' ', '')