O'Reilly logo

Sams Teach Yourself MySQL by Chris Newman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Operators with Strings

In the previous lesson, you saw how arithmetic and comparison operations were performed on numeric values. Now you’ll see the ways in which you can work with strings in MySQL.

Strings

A string is simply a collection of characters treated as a single data item, either returned from a database column that contains characters or enclosed in single quotes in a SQL statement.

Comparison Operators

The comparison operators you are already familiar with translate to string values in a logical way. The equals and not equals operators work almost as you would expect, but MySQL is not case sensitive when comparing characters. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required