Update a portion of text in a field

that functionalities for several days' and I would like to replace 'functionalities' by 'functionality' Would anyone knows how to replace JUST one word or a part of a text in a field without using an external program ? Please advise, thanks Best regards, Jacques Jocelyn

Re[2]: Update a portion of text in a field

Hello Daniel, DK> MySQL has a 'replace' function for this: DK> update table X set field1=replace(field1, 'functionalities', DK> 'functionality') where tableid=1; DK> http://dev.mysql.com/doc/mysql/en/String_functions.html Awesome ! Got it, thanks

Re: merging of two tables using temp tables???

ct ID,type,status,user,ID,uID from table1 left join table2 on ... where ... hope that helps. Best regards, Jacques Jocelyn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Optimize queries

out the bigTotal, can have that in the same query ? Please advise. Thanks Best regards, Jacques Jocelyn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re[2]: Optimize queries

hould be quite fast, so I don't think you should worry about having an DV> additional query. You may be right. I was just wondering, thanks for the input. I will go for two queries. thanks Best regards, Jacques Jocelyn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]