hello,
i would try this:
SELECT SUBSTRING(field,pos,len) AS mystring, id, blah FROM mytable WHERE
mystring LIKE '%ABC%';
regards,
Nuno Silva
andreas (@work) wrote:
> 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
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]