In what table are the listings custom field data kept.
I imported 900 businesses... manually by hand spent over 8 hours sorting everyone into multiple categories (pain in the ass) only to realize that one field is broke in every listing.
I added a hard url to a field in the import database:
However, I realize now that the custom fields recognize a url so I only needed the http://www.site.com/learnmore.php because my custom field shows only "a href=" on every record.
Im not re-importing 900 names to fix it just to spend another 8 hours sorting records into categories again.
I just want to find the field in my MySql database and do a find and replace on the url.. but I can not find any of the field data for any businesses? Where would they be?