I am using api express to connect to a database on hostbuddy.
I need to do a search to find a name, that part is simple. the problem I have is that the where requires exact match to the request.
I need to search on partial name matches. The column "FullName" in the database table has the full name "John Doe" but I need to find it by just "John" or "Doe". Or return everything that contains "John" or "Doe".
How do I add this to the service?
Hello Michael,
Please clarify, which exactly DB do you use? If it is SQL Db - you are able to use simple SQL queries in API Express: https://devcenter.appery.io/tutorials...
I'm using SQL Db.
I can run simple queries. I just need to query on partial match.
e.x. a search for "Mi" will return anything that contains "Mi" like "Michael" or "Mitchel" or "Mitch" or "Michell" or even "ccccc vvvvmivvvv"
I should also note this is a Jquery App
I't been 2 days, any help?
Please use query with %%, example please look at this topic: https://getsatisfaction.com/apperyio/...