sql-like Archives

[Solved] Can storing wildcard strings in a column (to be used with LIKE operator) cause unexpected query results or security issues?

October 11, 2022 by Kirat

The security flaw would — conceivably — arise if user input is put directly into the table without validation and users are limited to what they can see. That is, if ‘%’ could allow someone to see data they shouldn’t. However, using a column name for the like pattern is not a SQL injection risk, … Read more

[Solved] Like query for multiple condition check android

October 5, 2022 by Kirat

I think you are missing some logic operator between those two conditions. eg.: cursor = db.rawQuery(“SELECT * FROM videoplayer where ” + KEY_TAG_ONE + ” like ‘%”+ searchText +”%’ OR ” + KEY_TAG_TWO + ” like ‘%”+ searchText +”%'”, null); Which should select records where KEY_TAG_ONE or KEY_TAG_TWO contains searchText solved Like query for multiple … Read more

[Solved] SQL Like statement not working in Visual Basic

August 21, 2022 by Kirat

Try this: “SELECT user_name,forename,surname,game_cash,reg_group FROM tblGame WHERE user_name LIKE ‘%” + strSearchText + “%'” 0 solved SQL Like statement not working in Visual Basic