CODEWITHSUNDEEP
mysql
GummDev
GummDev

Reputation: 1170

MySQL Search strings

I'm looking for a way to get a row from a tabla which have a column data type of string. This column could have values as follows: 

 1. "1,2,3,4,5"
 2. "X,3,4,5,8"
 3. "X,X,3,4,5"
 4. "1,2,3,4,X"
 5. "1,3,4,X,X"

and so on, ...

I want to accomplish a search for a String like 

"1,2,3,4,5"

I tried with a 

SELECT * 
FROM *table_name* 
WHERE *column* LIKE '%1,2,3,4,5%';

hoping this query could retrieve at least three results (in the example, first, third and forth strings) but it returns only the first string, because of course it's the only string that matches with the specified criteria. Anyone knows a way for me to accomplish this achievement?

Upvotes: 1

Views: 65

Answers (1)

NetMage
NetMage

Reputation: 26936

I assume the X listed is literally the X character - if so, try

SELECT * FROM table WHERE '1,2,3,4,5' REGEXP REPLACE(column, 'X', '.')

Upvotes: 1

Related Questions