Q&A for users and developers of hardware and software for Raspberry Pi
SELECT DISTINCT TOP ##num?100## p.Id AS [Post Link] FROM Posts p JOIN PostHistory ph ON (ph.PostId=p.Id) cross join string_split(##words:string?e,a##, ',') WHERE text like concat('%', value ,'%') ORDER BY p.Id DESC