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 |