Search by game name

Need help with your application? Ask here.
Post Reply
calmeat
Posts: 3
Joined: Fri Nov 02, 2018 1:49 pm

Search by game name

Post by calmeat » Mon Nov 05, 2018 7:26 pm

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

User avatar
Zer0xFF
Posts: 253
Joined: Fri Apr 20, 2018 9:18 am

Re: Search by game name

Post by Zer0xFF » Mon Nov 05, 2018 11:08 pm

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
Regards
Zer0xFF

StainlessSteelRat
Posts: 11
Joined: Mon May 21, 2018 7:18 am

Re: Search by game name

Post by StainlessSteelRat » Tue Nov 06, 2018 7:45 pm

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.

HenryFeese
Posts: 1
Joined: Sat Mar 09, 2019 1:13 am

Search by game name

Post by HenryFeese » Wed Mar 13, 2019 10:49 am

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

BeJimmiePlaum
Posts: 2
Joined: Sun Aug 25, 2019 9:58 am

Search by game name

Post by BeJimmiePlaum » Wed Sep 04, 2019 9:46 am

Clicking any report authors name takes you to all their reports. I just checked and it works fine. What kind of search are you trying to do?

Post Reply