Results 1 to 5 of 5
Thread: Delete All Values in 1 Field
Feb 13, 2010, 22:33 #1
- Join Date
- Sep 2001
- St. Louis, MO
- 0 Post(s)
- 0 Thread(s)
Delete All Values in 1 Field
Hi everyone.... been a long time but I'm hung up with a very elementary problem that I need help with.
I have a table 'jos_comprofiler' that has a field named 'avatar'. This field contains the image name of each member's avatar for a membership site.
I simply want to know the query I'd use to delete all the data in the field 'avatar'.
This is a Community Builder Component database table for a joomla site. I'm doing a simultaneous migration and updating of the various extensions installed and the a lot of the old avatars are odd shaped and really look bad when resized into mini icons. I want to blow them away and have the members re upolad images with much stricter size limitations.
Thanks for any help