MySQL Cookbook

Section 5.0.  Introduction

Recipe 5.1.  String Properties

Recipe 5.2.  Choosing a String Data Type

Recipe 5.3.  Setting the Client Connection Character Set Properly

Recipe 5.4.  Writing String Literals

Recipe 5.5.  Checking a String's Character Set or Collation

Recipe 5.6.  Changing a String's Character Set or Collation

Recipe 5.7.  Converting the Lettercase of a String

Recipe 5.8.  Converting the Lettercase of a Stubborn String

Recipe 5.9.  Controlling Case Sensitivity in String Comparisons

Recipe 5.10.  Pattern Matching with SQL Patterns

Recipe 5.11.  Pattern Matching with Regular Expressions

Recipe 5.12.  Controlling Case Sensitivity in Pattern Matching

Recipe 5.13.  Breaking Apart or Combining Strings

Recipe 5.14.  Searching for Substrings

Recipe 5.15.  Using FULLTEXT Searches

Recipe 5.16.  Using a FULLTEXT Search with Short Words

Recipe 5.17.  Requiring or Excluding FULLTEXT Search Words

Recipe 5.18.  Performing Phrase Searches with a FULLTEXT Index