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:
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
:
Fax to:
06/16/2004 04:09 Subject: string compare
I am comparing songnames from two tables to find a match.
My query looks like this:
$querymvideo = select movietable.id, movietable.songname
from movietable where TRIM(movietable.songname) LIKE
'__$foo' ;
The above query works fine except when a songname has the
single quote symbol: ' or maybe