Mysql update 单张表单模糊匹配出的字段名
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
<a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=UPDATE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">UPDATE</a> edtt_implements <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=SET&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">SET</a> author_name = REPLACE ( author_name, 'aa', '梁瑞彬' ) <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=WHERE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">WHERE</a> book_name <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=LIKE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">LIKE</a> '%十万个为什么：%'; <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=SELECT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">SELECT</a> * <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=FROM&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">FROM</a> edtt_implements <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=WHERE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">WHERE</a> book_name <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=LIKE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">LIKE</a> '%十万个为什么：%'; |
edtt_implements为表名 author_name为要更改的字段 book_name为模糊匹配已知的字段。
二〇一四年五月八日 14:54:11
版权声明：
作者：龙魂
链接：https://blog.wlzs.cn/mysql-update-%e5%8d%95%e5%bc%a0%e8%a1%a8%e5%8d%95%e6%a8%a1%e7%b3%8a%e5%8c%b9%e9%85%8d%e5%87%ba%e7%9a%84%e5%ad%97%e6%ae%b5%e5%90%8d/
文章版权归作者所有，未经允许请勿转载。
THE END
