using LIKE with logical operators

Posted by ryanthegecko on Stack Overflow See other posts from Stack Overflow or by ryanthegecko
Published on 2009-11-04T16:02:33Z Indexed on 2010/04/07 1:43 UTC
Read the original article Hit count: 451

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?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about operators