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, '%');
Subject
Views
Written By
Posted
4863
April 21, 2012 07:46AM
2184
April 21, 2012 10:32PM
Re: SELECT * FROM product WHERE reference NOT LIKE %id%
2098
April 22, 2012 11:04PM
2305
April 24, 2012 09:35AM
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.