Welcome to WebmasterWorld Guest from 54.196.238.210

Forum Moderators: coopster & jatar k

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)

5+ 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 5+ Year Member



try using CHAR_LENGTH(xyzvalue)>2

weddingm

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

5+ Year Member



Thanks, that was a bone head mistake.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month