MySQL and Regular Expressions Help

ppowell

I need to do a very simple query in MySQL versions 3.23.41 and 4.0.10 whereby it would be something like this:

$sql = "SELECT * FROM image WHERE image_path LIKE '%$imageLocationPath/[a-zA-Z0-9\\-_\\.%]+\$%'"

However, I can't figure out how to do this. I went to various online tutorials including www.mysql.com and I'm sorry not a single one of them made an ounce of sense. Could someone please help me with this very simple task or point me in the right direction as to how to write this?

Thanx
Phil

gyoung

You need to use the REGEXP operator. Try something like this...

$sql = "SELECT * FROM image
WHERE image_path REGEXP '" . $imageLocationPath . "[a-zA-Z0-9-_.%]+\$%'";

http://www.mysql.com/doc/en/Regexp.html

ppowell

Yeah I figured that out yesterday.. never used that before in any version of SQL so it was a new one!

Thanx
Phil