Welcome to WebmasterWorld Guest from 54.198.77.172

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)

Junior Member

10+ Year Member

joined:Mar 9, 2006
posts: 177
votes: 0


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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 12, 2006
posts:2545
votes: 42


try using CHAR_LENGTH(xyzvalue)>2
4:12 pm on Aug 5, 2012 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 9, 2006
posts: 177
votes: 0


Thanks, that was a bone head mistake.