MySQL Forums
Forum List  »  Full-Text Search

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
SELECT * FROM product WHERE reference NOT LIKE %id%
4688
April 21, 2012 07:46AM


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.