+ Reply to Thread
Results 1 to 6 of 6

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

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

    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.

  2. #2
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    Hello,

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

  3. #3
    Master
    Join Date
    Apr 2021
    Location
    USA
    Posts
    248
    Quote Originally Posted by Rudi View Post
    Hello,

    Try to use rental_price = '' instead of rental_price = Null
    Yes Rudi,

    It worked. Thank you so much.

  4. #4
    Master
    Join Date
    Apr 2021
    Location
    USA
    Posts
    248
    Quote Originally Posted by Rudi View Post
    Hello,

    Try to use rental_price = '' instead of rental_price = Null
    Also Rudi,

    Is there an easy way to check Category_ID number?

  5. #5
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    Where do you need to check it and what for?

  6. #6
    Master
    Join Date
    Apr 2021
    Location
    USA
    Posts
    248
    Quote Originally Posted by Rudi View Post
    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.

+ Reply to Thread