Welcome to WebmasterWorld Guest from 54.145.209.34

Forum Moderators: coopster & jatar k

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

My Threads

Hot Threads This Week

Hot Threads This Month