PHP and MYsql regular expression 2

[ksoong]

Hi everyone,

I need help on how I can create a search engine that allows you to input regular expressions. (ie re*g*r would return "regular" from the Mysql database).

I'm trying to figure out the Mysql select statement that would includ the regular expression that I could use in a PHP query statement.

I've searched all over the net and can't find anything. can anybody help me?

 

[GirishGupta]

$q = "re*g*r";

$q = ereg_replace("*", "%", $q);

mysql_query("SELECT * FROM ... WHERE ... LIKE '%$q%'");

Does that help? Girish Gupta
girish@musicgoeson.com

 

[ksoong]

Yes very!

that is probably one of the most useful, to the point, responses i've received yet.