LIKE Clauses Back | Forward | Home

'Language Reference'
  • Logical Operators

  • Relational Operators

  • Data Types

  • Column Types

  • Primary Keys

  • Functions

  • Where Clauses

  • LIKE Clauses

  • Limit Clauses

  • OrderBy Clauses

  • Notes


  • User Functions

    Database Functions

    Data Manipulation Functions

    Table Functions

    Error Handling Functions

    << Last Section ( Where Clauses ) LIKE Clauses Next Section ( Limit Clauses ) >>

    LIKE clauses belong in an array and are in the following format.

         array('$column [!~|=~] $pattern')

    where $column is the column name, and $pattern is a simplified regex pattern. The regex pattern can contain the following items

  • '$' - end of string
  • '^' - begginning of string
  • '[$a|$b|$c...]' - matches either $a, or $b, or $c and so on
  • '[^$a|$b|$c...]' - matches NOT either $a, or $b, or $c and so on
  • '%' - Wildcard, meaning it matches anything

    User-Contributed Comments for:
    LIKE Clauses
    No comments found;