MySQL Forums
Forum List  »  Full-Text Search

Re: SELECT * FROM product WHERE reference NOT LIKE %id%
Posted by: Rick James
Date: April 22, 2012 11:04PM

Show us examples of rows that would be in "error".

Perhaps this would do it:
SELECT * FROM product WHERE reference NOT LIKE CONCAT(id, '%');

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SELECT * FROM product WHERE reference NOT LIKE %id%
2012
April 22, 2012 11:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.