SELECT * FROM product WHERE reference NOT LIKE %id%
Posted by:
Paul Polin
Date: April 21, 2012 07:46AM
Hello
in my table product i have 2 fields reference and id
the reference must always be id_some_text : 128 --> 128_red_hat
how can I search if there is and error
SELECT * FROM product WHERE reference NOT LIKE %id%
or
SELECT * FROM product WHERE reference NOT LIKE CONCAT(id, '_' , {?})
any idea ?
thank you
Edited 1 time(s). Last edit at 04/21/2012 10:31PM by Paul Polin.
Subject
Views
Written By
Posted
SELECT * FROM product WHERE reference NOT LIKE %id%
4859
April 21, 2012 07:46AM
2183
April 21, 2012 10:32PM
2097
April 22, 2012 11:04PM
2304
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.