Hi, i want to delete link details from phpld database which contains some words (spam world pills c@sin0 etc ) at present i am executing these one by one . ~~~~~~~~ delete from `PLD_LINK` where `TITLE` like ‘%word1%’ delete from `PLD_LINK` where `title` like ‘%word2%’ delete from `PLD_LINK` where `DESCRIPTION` like ‘%word2%’ delete from `PLD_LINK` where `DESCRIPTION` like ‘%word3%’ delete from `PLD_LINK` where `URL` like ‘%word1%’ delete from `PLD_LINK` where `URL` like ‘%word2%’ ~~~~~~~~ instead of doing all these one by one can i run one single query or some shortcut can i run multiple delete from query at once ?? could have done these one by one but i need to do this no 100 + dirs thts y looking for a better solution.
yeah, use OR command for example delete from PLD_LINK where (URL like '%word%') or (DESCRIPTION like '%word%') or even run from a php/asp page, passing a variable as %word% asp might be word = request.form("word") then run the command, that way you can type a keyword into a textbox, and delete all the entries containing that keyword.
Thanks dcr226uk well i am noob in sql. i just know some basic phpmyadmin things i think my query would be something like this delete from PLD_LINK where (URL like '%word%') or (DESCRIPTION like '%word%') or (TITLE like '%word%') & also what if i have more words will this work (URL like '%word%' , '%word2%')