using LIKE with logical operators
- by ryanthegecko
i can't seem to figure out how to combine LIKE with an OR or AND:
DELETE * FROM persons WHERE FirstName = 'Abe' AND LastName LIKE '%coln';
Looks like it should owrk to me but I get error 1064 (syntax0
Is there a correct way to do this?