mysql 批量替换的一个问题

以上内容是MYSQL的一个字段吗？希望用SQL语句来替换吗？

我非常负责的告诉你，MYSQL没有模式匹配功能，无法实现你这样的替换，你只有用其它语言（比如PHP）编写一个程序遍历数据库表的每一条记录，在PHP程序里面完成替换（用正则表达式），然后在UPDATE数据库表。

i think this should look like..

applet

jdbc->lokal server someport

lokal sever someport

get data_for_sqlserver

embed data_for_sqlserver ->post_http_data_for_sqlserver

socket port 80->http://yourwebserver/servlet

send post_http_data_for_sqlserver (use POST)

is this ok for u ?

remote server with servlet

getPost post_http_data_for_sqlserver

unwrap post_http_data_for_sqlserver ->data_for_sqlserver

socket->mysql on right port

send data_for_sqlserver

receive data_from_sqlserver

embed data_from_sqlserver ->http_response_data_from_sqlserver

sendResponse http_response_data_from_sqlserver

lokal server someport

receive http_response_data_from_sqlserver

unwrap http_response_data_from_sqlserver ->data_from_sqlserver

send data_from_sqlserver

applet

jdbc.get data_from_sqlserver ->ResultSet

as you can see this is a lot of work and im not sure if you can open a

serverport in untrusted applets.

so if you can connect to port 80 without a runing webserver you can

write your own jdbc-redirect-proxy

applet

jdbc->your jdbcproxy on port 80

jdbcproxy

get data_to_sqlserver

socket->mysql on right port

send data_to_sqlserver

get response ->data_from_sqlserver

send data_from_sqlserver

applet

jdbc.get data_from_sqlserver ->ResultSet

---