I am trying to do a SELECT with a LIKE condition with the parameter having a wildcard in it so that when a user searches in an input element, they don’t have to search an exact match for the sql server to return something. However when I set up the query in the SQL Database connection plugin, It giv…

I am basically trying to search an external database from the users input without having to make the user type an exact match. I have tried fixing this with the LIKE condition in the sql command but I get the results above. I have also tried using 2 different autocomplete plugins that allow you to d…

Hey Brandon, Have a look there : [image] Settings parameters for SQL Database [image] I am trying to connect to my SQL database to edit the amount of money that a certain user has, specified by user_id. However, whenever I try to run it using the set parameters, I just …

Hey Michel, I took a look at that thread and it doesn’t seem to help for my case. when changing the $1 to a ? I still get the same error. Good idea though. The error message comes from me adding in the % wildcard. The sql editor/plugin doesn’t seem to like that character. When I add it it seems to …

Oh I see… Don’t have the answer so, and interested by the solution. Hope someone here will give other ideas. Michel

Thank you though. I am going to try to do it with some regular expressions instead to see if that will work. Maybe someone else has and idea though.

Brandon, I have been looking for an answer for this and believe I figured it out. I have two suggestions. Use concat() to append the wildcard entry Use rtrim() to trim off any trailing spaces. Here is the search clause that I used to get it to work. select sum(inventory) as inventory, sum (mar…

Using SQL wildcard with SQL Database Connector

Need help Plugins

michelduprez April 23, 2020, 2:53pm 3

Hey Brandon,

Have a look there :

In your case, maybe LIKE ? would work ?

Michel

Topic		Replies	Views
SQL conection sintax APIs	7	606	October 26, 2020
Create a Search functionality connected to a MySQL Database through SQL Plugin APIs	1	913	December 28, 2020
How can I force a single quote (') or % character in my SQL LIKE query? Database	8	6101	May 12, 2019
SQL DB Connector - How to use parameter? Database	2	896	September 14, 2021
SQL Database Connector Plugin : Like query syntax error Need help	1	768	September 8, 2020

Using SQL wildcard with SQL Database Connector

Related topics