Wordpress search on a custom table

I have set up a custom table in my WP DB and have it all working in the admin backend of WP with WP_List_Table where I can edit and add new entries perfectly.

I have now moved on to the front-end side of things and what I am wanting to achieve is users being able to search for a name in that custom table from a page on the WP site which has a searchbox. They should be able to enter a name and it should return the data from the custom table. Note, there is no association between any of the WP tables and this custom table.

I have searched and searched for a solution that works for this but to no avail. Any help on how to get this going would be great.