check duplicate data in mysql in same cell

Question

I have column call: customer_mobile. but inside that cell they have data like

'0875555555,0875555555,0875555555,0875555555,0875555555' .

I want query if data duplicate will show 1

what do you mean with duplicate? You want to see if there are more than one number inside the cell? — user2399035
– user2399035, Commented May 4, 2018 at 9:44
you should consider to normalize your db. This is a really poor database structure for what I can see — user2399035
– user2399035, Commented May 4, 2018 at 9:44
There is no easy way to do this in mysql google mysql unstrng or mysql split string for ways to explode strings. — P.Salmon
– P.Salmon, Commented May 4, 2018 at 10:03

Pavan Sikarwar · Accepted Answer · 2018-05-04 10:48:42Z

1

You can find specific string in comma separated strings like this

SELECT FIND_IN_SET('0875555555', (SELECT customer_mobile FROM your_table_name)) as found

It will return position like 1,2,3,4 if found otherwise it will return 0

answered May 4, 2018 at 10:48

Pavan Sikarwar

8086 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1