[RESOLVED] how to write a wild card DELETE ??

[steamPunk]

Hi

how would i write a DELETE query that would delete all rows where the 'image' field starts with "myImg" so it would delete rows containing "myImg01.jpg", "myImg02.jpg", "myImg03.jpg" etc ?

thanks for your help

[troybtj]

$sql="DELETE FROM images WHERE name LIKE "myImg%";" ;
$result = mysql_query($query) or die(mysql_error());

$result will contain # of records deleted.

This assumes you have the host/database/user/password already defined with a require_once('mystufforwhatever.php'); defined.

[steamPunk]

i had to remove the quotes from "%myImg%" and replace with single quotes

DELETE FROM table WHERE field LIKE '%myImg%';

but it works fine

thank you

[troybtj]

My Bad, it's that time of the day, hence "67% correct". ...

Don't forget to mark thread resolved by clicking on "Thread Tools" at the top.