Probably the best solution in terms of performance and functionality would be to set a FULLTEXT index on the column and use the related fulltext search functions.