Post reply

Delete query with like option is not working

  • June 22, 2012 at 9:56 am

    #260383

    Hi friends ,

    I need to Delete from table with conditions :

    Example of my query!!!

    Delete from TAble A where Input_type like 'COLD%' and Input_type like 'ChartMover%'

    when I try to exceute the above query the result show '0 rows affected'

    where as when I try to check using "selete" actually there are records with "Input_type like 'ChartMover%'"

    But my delete is not working with same column to delete with 2 different likes??

    IS my query incorrect??

    Can anyone suggest

    Thanks in advance!!

  • June 22, 2012 at 10:01 am

    #1504610

    Duplicate post, post answers here.

  • June 22, 2012 at 10:04 am

    #1504614

    Hi..do you know how do delete duplicate posts??

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply