Mysql – SQL LIKE wildcard space character

mysqlsql

let's say I have a string in which the words are separated by 1 or more spaces and I want to use that string in and SQL LIKE condition. How do I make my SQL and tell it to match 1 or more blank space character in my string? Is there an SQL wildcard that I can use to do that?

Let me know

Best Solution

If you're just looking to get anything with atleast one blank / whitespace then you can do something like the following WHERE myField LIKE '% %'