When we search for players, is it possible we could get wildcard searches added? Like if I search for jack* or just 'Jack' I want all players with the last name Jackson or first name Jack, Jackson, etc.

Here I will write the query for you :)

Select * from player_table, stats_table where player_table.id = stats_table.player_id where player_table.first_name like 'Jack%' or player_table.last_name like 'Jack%';