How to delete all value from a listing field in one category?

Hi guys,

I'm trying to run a query to remove all value of listing field rental_price from category_id 2106 only
So I run this

Code:

---

Only registered members can view the code.

---

But I got error:

Code:

---

Only registered members can view the code.

---

I tried going to Structures in phpmyadmin to check on the Null checkbox and hit Save button, but it won't change.
Attachment 4530

I did some research and found these code to change rental_price to nullable

Code:

---

Only registered members can view the code.

---

But none of them work :(

Is there any solution to this?
Thank you

Hello,

Try to use rental_price = '' instead of rental_price = Null

Quote:

---

Originally Posted by Rudi

Hello,

Try to use rental_price = '' instead of rental_price = Null

---

Yes Rudi,

It worked. Thank you so much. ^_^

Quote:

---

Originally Posted by Rudi

Hello,

Try to use rental_price = '' instead of rental_price = Null

---

Also Rudi,

Is there an easy way to check Category_ID number?

Where do you need to check it and what for?

Quote:

---

Originally Posted by Rudi

Where do you need to check it and what for?

---

I just want to do some copying and removing in phpmyadmin like the inquiry above, I had to check flynax_listings table to find the category_id. :(