Search by game name

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

Search by game name

Post 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

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

Re: Search by game name

Post by Zer0xFF »


the database does search with a like ... 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.


Posts: 29
Joined: Mon May 21, 2018 7:18 am

Re: Search by game name

Post 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.

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

Search by game name

Post by HenryFeese »

How to search ONLY in the filename, excluding the extension?

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?


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

Search by game name

Post by BeJimmiePlaum »

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