'How do you search database record with multiple words?

So, say i have a record in database like "Something with corn".

if i use sql like "SELECT * FROM table WHERE column LIKE '%Something corn%'", the record wont show.

is there a way so when i search "Something Corn", i can get the record.

Thanks...

sql ms-access

Solution 1:^[1]

SELECT * FROM table WHERE column LIKE '%Something%corn%';

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	Jonas Metzler