MySQL Forums
Forum List  »  Newbie

REPLACE Sql
Posted by: Filipe Miranda
Date: April 26, 2018 04:02AM

i have a table collumn widh multiple values like that
Values-> 1;2;3;4;5;6;7
Now i need check if some input is contained there
I try some like this "select value_2 from data where active=1 and 2 in(
select REPLACE(value,';',',') cats from data)" but nothing returned

Options: ReplyQuote


Subject
Written By
Posted
REPLACE Sql
April 26, 2018 04:02AM
April 26, 2018 05:06AM


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.