.. ==================================================
.. FOR YOUR INFORMATION
.. --------------------------------------------------
.. -*- coding: utf-8 -*- with BOM.

.. include:: ../../../../../../Includes.txt


.. _developers_mapping_general_tca_ctrl_sql:


SQL
===

You can extend your database query with a SQL andWhere like in the snippet below.


Code
----

.. code:: php

  ...
  $GLOBALS[ 'TCA' ][ $_table ][ 'ctrl' ][ 'immo24' ] = [
    'ctrl' => [
        'sql' => [
            'andWhere' => ' AND category LIKE "Wohnen" AND immoart LIKE "Mietwohnung"',
        ],
  ...


Details
-------

See details @ mapping.php in the :ref:`samples <developers_samples>` Apartment, Contact and Site.