Forum
Partial word search
Can I search for partial words? In our job site if I search for 'Designer' it will return a result if I search for 'Design' it returns nothing. Is there a way of searching for the string rather than the whole word? This is a problem as we have built a job site and would like people to be able to find jobs without necessarily getting the exact working where appropriate.
How are you searching? Full text search or a filter?
Full text search
MySQL fulltext search doesn't support word stemming currently. I think it may be slated for MySQL 7.