DEPRECATION WARNING
This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.
Small Cookbook¶
Database Structure¶
MySQL supports text
columns as part of a WHERE
clause using equality
while Oracle for instance does not. This means that if you need to do
something like that:
SELECT * FROM tx_ext WHERE column = 'something'
Make sure not to use text
as column type but instead use
varchar(4000)
which is the limit for Oracle. The other solution is
to use a LIKE
operator:
SELECT * FROM tx_ext WHERE column LIKE 'something'
WHERE Clauses¶
The SQL parser is not as powerful as it could be. Typical problems occur with calculated conditions such as
... WHERE column1 + number1 >= number2
Rules of thumb¶
- The calculated part (
column1 + number1
) must start with a column name - The calculated part may have a column name or a number as second operand
- The part after the operator (
number2
) must be a number - The calculated part can only occur on the left hand of the comparison operator
- More than two operands on the left hand are not supported