% Character - MySQL

['LinKin]

Hello,

When I am going to search the row(s) where a column matches this symbol: %

MySQL returns me every row from the Database!

But it doesn't return me the value of the column where I search for the matches.

I'm using this code to make the searches:

local theQuery = dbPoll(dbQuery(dbHandler, "SELECT * FROM `myTable` WHERE `myColumn` LIKE ?", "%"..theArg.."%"), -1) 

Note that the variable 'theArg' is the string that I'm looking matches for. So in this case it is '%'

I've seen that % symbol has a special use in MySQL, however I don't understand what it really does.

[MIKI785]

As far as i know it works like a wild card.. so if you search for b, it will return anything that contains b, so for example ab, abc, or bc..

['LinKin]

I see no other solution that not letting % character be input in the text to make the search.

Thank you

[MIKI785]

Yes, if you want to make exact match then don't put in any %.