Pichu Bros. Mini - Skateboard (Japan) (Preview) My script will search the DB for that but it will come up empty. I would Like it to show LIKE matches instead. Is there a way to do the query and use
LIKE Pichu Bros. Mini - Skateboard (Japan) (Preview) so it will return titles that are matched or Closely matched?
so for the above example it would return
Pichu Bros. Mini as a Like match?
If i need to be more clear please let me know. Thanks
the database does search with a like https://github.com/TheGamesDB/TheGamesD ... I.php#L267
however, i think the old site/API was too generous, in that it would split and search each word, which is something im not sure should be implemented at all, if anything, this should really be something the devs on the other end (aka you) should deal with, in that you should try to create the proper search query from the data you have, since you and your users are not the only ones using this database, while i feel we should return as accurate results as possible from our end.
At minimum, a fuzzy search should be used when adding a new game and a warning should be displayed to users using the sitewide web based search.
Regardless of whether youre using SQL or elastic search to do this (which has fuzzy built in) this should really be addressed.
Finally, it makes no sense to have search API. You might as well remove it. The limit is too low to make it useful, and people should be mirroring anyway.