If statement query

[e1seix]

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!

[trq]

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.

[jvrothjr]

MysqlQstring = "Select * from tablename where fieldname like '%value%';

 

this can be done as an mysql query