Forum | Appery.io

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