mysql - SUBSTRING
| From: | andreas \(@work\) | Date: | Sat, 12 May 2001 08:12:16 +0000 |
| Subject: | mysql - SUBSTRING | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-52552@lists.php.net to get a copy of this message | ||
hi,
if i use SUBSTRING(field,pos,len) in a SELECT statement it works fine
but i cant work it out how to use this function in the WHERE clause
... WHERE SUBSTRING(field,pos,len) LIKE "ABC"
... WHERE SUBSTRING(field,pos,len) = 'ABC'
... WHERE SUBSTRING(field,pos,len) LIKE 'ABC'
none of them work
is this not possible or whats wrong ?
thank you
andreas