Home    Back    Forward    Refresh    txtSQL Homepage

LIKE 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 Comments - LIKE Clauses
    No comments posted yet;
    Last Page Next Page

    'Language Reference'
  • Logical Operators
  • Relational Operators
  • Data Types
  • Column Types
  • Primary Keys
  • Functions
  • Where Clauses
  • LIKE Clauses
  • Limit Clauses
  • OrderBy Clauses
  • Notes
  • txtSQL 3.0.0 Beta Readme

    User Functions

    Database Functions

    Data Manipulation Functions

    Table Functions

    Error Handling Functions

    SQL Syntax

  • [ txtSQL Documentation powered by txtSQL | 6 SQL Queries ]