Page 1 of 1

Search by game name

Posted: Mon Nov 05, 2018 7:26 pm
by calmeat
So I am trying to search by game name and was wondering if the name has to be an exact match of what is in the DB. On the old API it would still bring up LIKE matches if the string i am searching does not match title in the DB. For example
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

Re: Search by game name

Posted: Mon Nov 05, 2018 11:08 pm
by Zer0xFF
Hi,

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.

Regards
Zer0xFF

Re: Search by game name

Posted: Tue Nov 06, 2018 7:45 pm
by StainlessSteelRat
IMO, a fuzzy search (one implementation of which is similar to what you said, searching each word) is a common approach, or rather the only approach thatb works. Otherwise, you give a false idea that these games do not exist and incur more duplicates.

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.

Search by game name

Posted: Wed Mar 13, 2019 10:49 am
by HenryFeese
How to search ONLY in the filename, excluding the extension?

Example:
IВґve 1000s of files .MHT all included HTML and I need to find files with mht in the name, files about the MHT format, p. ex.

Any possibility, in Everything?

Thanks