View Single Post
Old 09-17-2021, 03:08 AM  
zijlstravideo
Confirmed User
 
zijlstravideo's Avatar
 
Industry Role:
Join Date: Sep 2013
Location: The Netherlands
Posts: 805
Quote:
Originally Posted by ZTT View Post
If you don't need the data from the database and don't need to change it there's no reason to even access the database. Are you trolling?

$pet = 'zombie';





It may not be what he wanted, but he said it repeatedly:

"How do I replace whatever is in that 'pets' column with the word 'zombie' no matter if its dog, fish, cat, porcupine, etc?"

"the replace is what I am trying to do but being lazy about it and not having to type out a few hundred individual words to replace with 'zombie'"

"Is there a command such as REPLACE_COLUMN which will just change the data in that specific 'pets' column irrespective of the rows value?"
UPDATE yourTable
SET pets = zombie

?
__________________
Contact: email
zijlstravideo is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote