任何人都可以建议从字符串中找到单词吗？

Question

I am using PHP/MYSQL for my major project in college. It is a search engine I made.

My database contain results for this sentence 'who is the first president of america'.

My question is, when user enter the same query without white space (e.g.: 'whoisthefirstpresidentofamerica') my search engine fails to retrieve results from the database.

Is there anyway to find words from string which doesn't contain spaces?

Answer 1

Use LIKE keyword

select * from tablename where fieldname LIKE 'value%';