Genezzo::Havok::SQLCompare

Genezzo::Havok::SQLCompare is a Perl module with SQL comparison functions.
Download

Genezzo::Havok::SQLCompare Ranking & Summary

Advertisement

  • Rating:
  • License:
  • GPL
  • Price:
  • FREE
  • Publisher Name:
  • Jeffrey I. Cohen
  • Publisher web site:
  • http://search.cpan.org/~jcohen/Genezzo-0.72/lib/Genezzo.pm

Genezzo::Havok::SQLCompare Tags


Genezzo::Havok::SQLCompare Description

Genezzo::Havok::SQLCompare is a Perl module with SQL comparison functions. Genezzo::Havok::SQLCompare is a Perl module with SQL comparison functions.SYNOPSISHavokUse("Genezzo::Havok::SQLCompare")FUNCTIONSSQL functionsIN WHERE value IN (list)Returns TRUE if the value is present in the list, else FALSE. NOT IN is slightly different: returns NULL if any list item is NULL, return FALSE if the value matches any list item, else returns TRUE.LIKE WHERE value LIKE (pattern) WHERE value LIKE (pattern, escape_char)Returns TRUE if the value matches the pattern. In the pattern, a '%' (percent sign) matches zero or more characters, and an '_' (underscore) matches exactly one character. These characters can be matched as literals if they are preceded by the optional escape character.LIMITATIONS· IN has list support, but no IN subquery support.· LIKE has a "functional" syntax, instead of the standard 'LIKE pattern '. Requirements: · Perl


Genezzo::Havok::SQLCompare Related Software