Need query to get list of exercises/users

[andrew07039]

Need query to get list of exercises/users

[ppegusii]

Please explain further.

[andrew07039]

So I will give a string as a query, which then requests something from the database either look through only description or name, muscle group etc as well. I will then need an array with exercises back for the encyclopedia search. I will need an array with users back from the user search

[ppegusii]

It sounds like you want two queries, one for users and one for exercises. Please specify exactly what tables and columns you want searched in each. I do not want to spend a lot of time writing a query that is not what you want.

[andrew07039]

Definitely name, and description for exercises and muscle group maybe (you don't have to put this one if you don't want to)
Users just username for now

[ppegusii]

somewhat done. exercisesSearchByNameDescriptionMusclegroup, usersSearchByUsername
Both searches use LIKE. It's fine for the user search, but for exercise search it's only useful for one word queries. Let me know if you NEED multi-word queries and I can use regular expressions, but this is non-trivial because I'll have to parse the query into words or maybe look for a node module.