I'm trying to do a select unique from author column in a MySQL table - but the data as input previously unfortunately sometimes has one space and sometimes has two spaces between the first and last name in the column.
How do I fix this in the db or make a query that will ignore varying amounts of blank spaces. THere are over 90k names so I don't want to have to do it manually ;-)
Column is as:
Smith, Bob
but urlencoded that might show up as
Smith,+Bob or
Smith,++Bob
They look the same in the browser - but I need them to be the same in terms of SELECT DISTINCT
How do I fix this in the db or make a query that will ignore varying amounts of blank spaces. THere are over 90k names so I don't want to have to do it manually ;-)
Column is as:
Smith, Bob
but urlencoded that might show up as
Smith,+Bob or
Smith,++Bob
They look the same in the browser - but I need them to be the same in terms of SELECT DISTINCT