If the bracketed stuff really can be anything, you're better off doing it
externally, I guess. If you can be reasonably sure that there'll not be any
square brackets in there, you can fluff about with instr() and substr().
On Sat, Jan 22, 2011 at 6:18 PM, Eric Bergen wrote:
> There isn't a buil
There isn't a built in way but you can try
http://www.mysqludf.org/lib_mysqludf_preg/
I would go with the php/perl script if this is a one time thing.
-Eric
On Jan 21, 2011, at 11:31 AM, Phil wrote:
> I have a table which contains a username column which may be constructed
> something like
>
I have a table which contains a username column which may be constructed
something like
somename[A] or [DDD]someothername
The A or DDD can be anything at all.
I've added a new column to the table to which I'd like to populate with the
value within the square brackets.
I
Is there a fast way to update a column in one table with the column value
in another table? Here's the catch. I need to do this for up to 10,000 rows.
I would like to do this with one sql statement rather than writing a PHP
loop to do it.
I have 2 tables, Dept and Employee. I want to coun
UPDATE table SET name = REPLACE(name,'blue','');
- Original Message -
From: "Tiago Mota" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 9:43 AM
Subject: update a column
> Hi,
>
> I have a book explanning mys
Hi,
I have a book explanning mysql and the commands, and I was here searching
for some kind of a command that do waht I want. But I didn't find
anything
I have a table named as mytable and two columns (id, name).
Like this
id name
1 blue dot
2 blue pencil
3 blue pen
.
And I want to alter
