e1seix Posted February 14, 2008 Share Posted February 14, 2008 i have one for you. trying to establish whether this is possible. we all know we can use "==" and "!=" in an if statment to determine "equal to" and "definitely not equal to." is there something we can use that is similar to "LIKE '%whatever%'" in mysql? i need to use an if statement to determine a list of specific products from a large database. unfortunately the only identifier is in a string with a variable. i know it can be done using regex, but that's a lot of work and was wondering if there's a quicker way? cheers! Quote Link to comment Share on other sites More sharing options...
trq Posted February 14, 2008 Share Posted February 14, 2008 i know it can be done using regex, but that's a lot of work and was wondering if there's a quicker way? Nope, this is exactly what regex is for. Quote Link to comment Share on other sites More sharing options...
jvrothjr Posted February 14, 2008 Share Posted February 14, 2008 MysqlQstring = "Select * from tablename where fieldname like '%value%'; this can be done as an mysql query Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.