Re: mysql - SUBSTRING
| From: | Nuno Silva | Date: | Mon, 14 May 2001 01:06:02 +0000 |
| Subject: | Re: mysql - SUBSTRING | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-52644@lists.php.net to get a copy of this message | ||
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