Mysql update 单张表单模糊匹配出的字段名

2014年5月8日 4430点热度 2人点赞 0条评论

<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> '%十万个为什么：%';

<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>

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>

edtt_implements为表名 author_name为要更改的字段 book_name为模糊匹配已知的字段。

二〇一四年五月八日 14:54:11

本作品采用知识共享署名 4.0 国际许可协议进行许可