When used in informix fuzzy query you great god pray to reassure due to receive much more behind a string of a space led to query less than go through trial and error in the intensive situation for everybody to help reassure thank you
To get their fields such as: "qwer"; There is a space behind qwer
SQL 1: select * from table where STR like '% qwer %'; Query less than qwer behind also has a space
SQL 2: select * from table where STR like 'qwer %'; I can query qwer behind also has a space
SQL 3: select * from table where STR like '% qwer %'; I can query qwer behind also has a space also has a space behind the second %

Don't know what's the difference between the three SQL why doesn't seem to find the SQL query results once again thank you for the great god worship!!!!!!

CodePudding user response:

SQL2 understandable

What is the difference between SQL3 and SQL1?