SQLTeam.com | Weblogs | Forums

Finding doubled values

mysql

#1

I need to find in a row of my table all the values that are repetitive, e.g. 123text123text (there might be a line break between the repetitive sub-strings.

So I need an SQL query that tells mysql in PhpMyAdmin to return all instances were sub-string first half of value == sub-string second half of value.

I don't think i need regex for my query it just needs to select values from the row were sub-string from begin until half of string equals sub-string from half of string until end Thanks!


#2

You'll want to post your question on a site that specializes in MySql. SQLTeam is for Microsoft SQL Server.