Re: Update query question

quot; <[EMAIL PROTECTED]> To: Sent: Saturday, February 03, 2007 8:42 AM Subject: Update query question I am new to mysql. I am trying to do a simple update query to update a field based on the contents of another field in the same table. Here is what I have. update inventory_items se

Update query question

I am new to mysql. I am trying to do a simple update query to update a field based on the contents of another field in the same table. Here is what I have. update inventory_items set name = "necklace" where description like "%necklace%"; I am not sure what is wrong. select * from inventory_items w

RE: update query question

[EMAIL PROTECTED] on Wednesday, July 07, 2004 11:08 AM said: > Have you tried this other way of making an inner join? no i did not because i did know you could do a JOIN on an UPDATE. thanks for your suggestions i will try them out. chris. -- MySQL General Mailin

Re: update query question

| | Fax to: | |

update query question

hello, i've had to change some of the tables in my db to accomodate some greater flexibility in the application that uses it and because of this i need to go through and update all the records. i've done one table by hand and it had about 100 records and took about 20 minutes. but this next table