去掉mysql查询字段的空格问题

[flyingcloud_zyf]

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 就是 ‘中 国’

这问题着急 望指点

[amani11]

REPLACE(xc_match.match_name, ' ', '')

[kyzy_yy_pm]

[Quote=引用 1 楼 amani11 的回复:]
REPLACE(xc_match.match_name, ' ', '')
[/Quote]+

[gumwzg]

[Quote=引用 1 楼 amani11 的回复:]
REPLACE(xc_match.match_name, ' ', '')
[/Quote]
++

[Dleno]

[Quote=引用 1 楼 amani11 的回复:]

REPLACE(xc_match.match_name, ' ', '')
[/Quote]

+++

接上，哈哈