[RESOLVED] Select Character Limiting (MySQL)

Hi just a quick question.

Say you have a field in a database named MyString. It has a value of 25082006121228.

How do you write a select statement that queries that field on only the first 8 characters.

For example:

SELECT * FROM `MyTable` WHERE MyString =  25082006

Thanks

Jon

SELECT * FROM `MyTable` WHERE CAST(MyString as CHAR) LIKE '25082006%'

(Must be using MySQL 4.0.6 or newer)

SELECT * FROM MyTable WHERE SUBSTR(MyString, 1, 8) = '25082006'

konrad - is your example mysql 3> ?

Resolved. It's SUBSTRING as opposed to SUBSTR

Thanks