Welcome to WebmasterWorld Guest from 54.162.240.235

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

little help with sql statement

trying to add strlen to statement

     
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!
2:38 pm on Aug 5, 2012 (gmt 0)

WebmasterWorld Senior Member 5+ Year Member



try using CHAR_LENGTH(xyzvalue)>2
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