Delphi7 in how to use SQL statements to access database exact query and fuzzy query, the database of data type for the digital not text, please everyone a great god for help

CodePudding user response:

This with DELPHI it doesn't matter.
SQL query to the precise condition query, use=, fuzzy, is also the same in the like figures.

CodePudding user response:

I use the text type of database can use SQL to achieve precise query, when changing the database to digital type precise query cannot be used, after running tips I does not accord with the standard type, so I'm not sure how to modify my statement

CodePudding user response:

Select * from table where id=121

Select * from table where id like '% 121%'

CodePudding user response:

Program the ginseng, Numbers and text, in program is different, need to pay attention to

CodePudding user response:

I didn't quite understand what should mention the

CodePudding user response:

Fuzzy queries using the select * from tablename where field like '% % edit1. The text'

CodePudding user response:

Numeric types, you need not quotes,

CodePudding user response:

Numeric types, you need not quotes,