SELECT * FROM product WHERE reference NOT LIKE %id%

[Paul Polin]

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.