string compare

[Bob Lockie]

Where is the syntax error in this?
select name from users where name like '%' and strcmp( substr(name from 
1 for 3), 'abc' )=0;

Why should I use strcmp since "MySQL automatically converts numbers to 
strings as necessary, and vice versa."?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]