Welcome to WebmasterWorld Guest from 34.203.28.212

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 Top Contributors Of The Month

joined:Feb 12, 2006
posts:2709
votes: 116


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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members