Results 1 to 6 of 6

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

Threaded View

  1. #1
    Master
    Join Date
    Apr 2021
    Location
    USA
    Posts
    262

    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.
    Screen Shot 2022-03-15 at 3.44.11 PM.png

    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
    Last edited by Tim Copper; March 15, 2022 at 08:57 AM.