By v8powerage on

I've been using image_attach.module where title was optional (until I made patch for that), but still I have lot's of images without title which I wanna delete, was trying this but wouldn't work:

DELETE node WHERE title=NULL

Any help much appreciated.

⋅ Categories: Drupal 6.x

Comments

vertazzar’s picture

vertazzar commented

try SELECT * FROM `node` WHERE `title` = '' LIMIT 0,1000

or SELECT * FROM `node` WHERE `title` IS NULL LIMIT 0,1000

In phpmyadmin