| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|little help with sql statement|
trying to add strlen to statement
| 2:28 pm on Aug 5, 2012 (gmt 0)|
Is it possible to add ad strlen statement into a sql statement?
$sqlstatment="SELECT * FROM table WHERE strlen(xyzvalue)>2 AND value LIKE '%verified%'";
| 2:38 pm on Aug 5, 2012 (gmt 0)|
try using CHAR_LENGTH(xyzvalue)>2
| 4:12 pm on Aug 5, 2012 (gmt 0)|
Thanks, that was a bone head mistake.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved