Bob Lockie wrote:
Where is the syntax error in this?
select name from users where name like '%' and strcmp( substr(name from 1 for 3), 'abc' )=0;
substr(name,1,3) Check the manual. You don't include the 'from' and 'for'.
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]
