Dumb SQL questions

Joans · **Joined:** 31st Mar, 2008 **Posts:** 8653

Right, my brain has shut down due to lack of sleep, so I really just want someone to tell me how to do this as I am clearly rubbish.

I have a load of part numbers in a table that should be AS1-..., unfortunately, some genius has been putting them in as ASI-...
How can I update the ASI- to AS1-?

GazChap · **Posted:** Wed Sep 16, 2009 12:22

UPDATE `table` SET `column`=REPLACE(`column`, 'ASI-', 'AS1-');

myp · **Posted:** Wed Sep 16, 2009 12:23

Isn't it something like:

Code:

update table_name 
     set row1 = "AS1-"
     where row1 = "ASI-"

I haven't done SQL for about three years now, though, so it could be wrong.

Joans · **Joined:** 31st Mar, 2008 **Posts:** 8653

GazChap wrote:

UPDATE `table` SET `column`=REPLACE(`column`, 'ASI-', 'AS1-');

Yeah, this dawned on me after I'd posted. Done it now, thanks anyway.

Joans · **Joined:** 31st Mar, 2008 **Posts:** 8653

myp wrote:

Isn't it something like:

Code:

update table_name 
     set row1 = "AS1-"
     where row1 = "ASI-"

I haven't done SQL for about three years now, though, so it could be wrong.

Oh my god, yes, it's wrong.

(Although technically, that probably wouldn't have done anything

)

myp · **Posted:** Wed Sep 16, 2009 12:35

Every time I learn something new it pushes old stuff out of my brain.

Joans · **Joined:** 31st Mar, 2008 **Posts:** 8653

myp wrote:

Every time I learn something new it pushes old stuff out of my brain.

I know the feeling, except it always pushes the useful stuff out, rather than all the pointless stuff that I can still remember.

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49237

To be fair, if the values were actually 'AS1-' rather than 'AS1-XXXXXXX', myp's answer would have been fine.

TheAlbin0Kid · **Posted:** Wed Sep 16, 2009 13:30

Craster wrote:

To be fair, if the values were actually 'AS1-' rather than 'AS1-XXXXXXX', myp's answer would have been fine.

Hush, don't defend him.

myp · **Posted:** Wed Sep 16, 2009 13:33

Actually, I didn't even notice that. I just thought Joans was putting ellipses in to finish his sentences.

Joans · **Joined:** 31st Mar, 2008 **Posts:** 8653

Craster wrote:

To be fair, if the values were actually 'AS1-' rather than 'AS1-XXXXXXX', myp's answer would have been fine.

Yeah, but if that was the case, I shouldn't have needed to ask the question (although you might say I shouldn't have needed to anyway).

Be Excellent To Each Other

Dumb SQL questions

Who is online