Eine Einführung in
|
| SQLite | ||
|
The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to SQLite | ||
| none | ||
| DB2 | ||
|
The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to DB2 | ||
| none | ||
| MS Access | ||
|
The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to MS Access | ||
| String comparison in Access is alway case insensitive. | ||
| PostgreSQL | ||
|
The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to PostgreSQL | ||
| The LIKE command is case sensitive - to do a case insensitive search you should force the searched field and the search term into lower (or upper) case. Without this we would miss "Bahamas, The" | ||
| Oracle | ||
|
The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to Oracle | ||
| The LIKE command is case sensitive - to do a case insensitive search you should force the searched field and the search term into lower (or upper) case. Without this we would miss "Bahamas, The" | ||
| MS SQL Server | ||
|
The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to MS SQL Server | ||
| The LIKE operator is case insensitive. | ||
| MySQL | ||
|
The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to MySQL | ||
| The LIKE operator is case insensitive. | ||
| Sybase | ||
|
The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to Sybase | ||
| none | ||
| Mimer SQL | ||
|
The "brute force" method is to use use the LIKE operator against any of the fields to be searched. This will be relatively expensive - but probably good enough in many cases. The term to search for should be quoted and placed within two wild cards. You should construct the string literal in some scripting language - don't forget to quote it. | ||
| Specific to Mimer SQL | ||
| none | ||