deleting from mysql

[bakaneko]

is there a way to delete all instance of a word from a table? insteal of going through each field?

thx,

bakaneko

[downsize]

hmm never did this before, but I would grab the table field from mysql (one at a time in a loop), remove the word and update the record

something like:

//...get your data from mysql
//$datafrommysql assuming this is the variable with your string from the db

str_replace("theword", "", $datafrommysql);

//now update that record in mysql
// update tablename set fieldyouedited='$datafrommysql'

hope that gives you some direction.

[bakaneko]

thanks for the reply but the thing is that my i want this delete to work on all the fields regardless of its name. because the column name itself can be different throughout all the matching fields. I know a long way to do this but i was just wondering if there was some short notation in mysql to do this.

=)

[downsize]

even id fields and/or number only (ints, etc) fields?

well, you could do a SELECT * and then rip through each and every field. then putting it back is involved by getting the field name from the array you ripped through and performing the update.

sounds like a CPU load test to me (if you have any amount of records to speak of) :-}

[bakaneko]

ya. that is what i am trying to avoid doing as it will be very messy. =/