جستجو کالا

[mazoolagh]

اینجوری هم میشه نوشت:

USE SHOWS;



declare @Words nvarchar(max)=N'man the gun';

declare @Words_Count int = (SELECT COUNT(value) FROM STRING_SPLIT(@Words,N' '));



WITH All_Words AS (

    SELECT value

    FROM STRING_SPLIT(@Words,N' ')

)



SELECT IMDBID , Title , Genres 

    FROM Shows

    WHERE 

        (SELECT COUNT(value)

            FROM All_Words

            WHERE shows.title LIKE N'%' + value + '%'

        ) = @Words_Count