How do you search database record with multiple words?-CodePudding

Home > Net > How do you search database record with multiple words?

How do you search database record with multiple words?

Time：05-13

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...

CodePudding user response：

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