Please enable JavaScript
To filter or search records in Lightning Datatable, use JavaScript includes(). Doing Apex call and using LIKE operator in the SOQL is not needed as we can filter the records in the Lightning Web Component JavaScript itself. Blog Post: https://www.infallibletechie.com/2022/01/filtersearch-in-lightning-datatable-in.html