Hi Rolando,
This is perfect solution I was looking for.
Why do you use left join here? It looks like inner join works fine as well.
Thanks.
Rolando Edwards wrote:
I ran these commands:
use test
DROP TABLE IF EXISTS mydata;
CREATE TABLE mydata (id INT NOT NULL AUTO_INCREMENT PRIMARY
In regards to this issue, I submitted a bug.
http://bugs.mysql.com/56157
nixofortune wrote:
Hi ALL,
I just start using Workbench 5.2.26 CE and this is a problem I have.
When I try to run a query with a case statement, columns with datetime
Type shown as BLOB in output window.
To see the
Hi ALL,
I wonder if possible at all to use replace() together with regex in
update statement.
I want to be able to update a field of string values and replace a
'dash' character with a space in the string.
Something like:
UPDATE table SET column = replace(column, regex '%-%', ' ') where id
Thanks Dan,
I tested it just now. It works perfectly.
Dan Nelson wrote:
In the last episode (Jul 08), Egor Shevtsov said:
I wonder if possible at all to use replace() together with regex in update
statement. I want to be able to update a field of string values and
replace a 'dash