Hope you first follow this link Create filter search using custom Pipe. Then if now you want to show that search results are not found then follow the below code.
<ng-container *ngIf=”(items | filter:search.value) as result”>
<div *ngFor=”let item of result”>
{{item}}
</div>
<p>Count: <b>{{result.length}}</b></p>
</ng-container>









![SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes](https://blog.rahulbhutani.com/wp-content/uploads/2020/04/123-218x150.jpg)








