Forum Moderators: coopster

Message Too Old, No Replies

little help with sql statement

trying to add strlen to statement

         

weddingm

2:28 pm on Aug 5, 2012 (gmt 0)

10+ Year Member



Hi,


Is it possible to add ad strlen statement into a sql statement?

Example:
 $sqlstatment="SELECT * FROM table WHERE strlen(xyzvalue)>2 AND value LIKE '%verified%'"; 


Thanks!

londrum

2:38 pm on Aug 5, 2012 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



try using CHAR_LENGTH(xyzvalue)>2

weddingm

4:12 pm on Aug 5, 2012 (gmt 0)

10+ Year Member



Thanks, that was a bone head mistake.