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: 449
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