Dynamo3209
Programmer
Hi,
I am trying to delete multiple rows from one table and using this following query
This query only deletes the first email address in the array that is only a@hotmail.com is deleted.
An array with int type can be deleted in this way, but can we delete a varchar type array with such query.
Thanks,
Dynamo
I am trying to delete multiple rows from one table and using this following query
Code:
Delete from table WHERE name IN ('a@hotmail.com',' b@hotmail.com',' j@yahoo.com',' j@gmail.com')
An array with int type can be deleted in this way, but can we delete a varchar type array with such query.
Thanks,
Dynamo