SELECT * FROM database WHERE Name contains "abc" AND "xyz" AND "123" -- as opposed to containing "abc xyz 123" -- please ignore my sql Syntax,I am an absolute beginner
谢谢.
SELECT t.* FROM atable t INNER JOIN dbo.Split(@UserInput,' ') s ON t.Name LIKE '%' + s.Data + '%'
