SQL Search BUT ignore dashes

Hi. I'm developing a MySQL application and I need to search a column for certain text, but ignore dashes SQL Search BUT ignore dashes

IE "abc123" should match both "abc123" and "abc-123"

This can be done in perl but need it 100% to be done in MySQL syntax for speed purposes SQL Search BUT ignore dashes

Something like:
select * from TABLENAME where title like '%abc123%'

^^ but it should also match abc-123

Any help would be appreciated

 

 

 

 

Top