1 reply to this topic

[Nathan Malone]

Hey, I'm still working away at my search engine (it was harder then I thought it would be!) but I ran into one little problem in a mysql query.

I want to select a mysql table row(s) where the first part of a column starts with $asdf2 but the next part can be anything. I think that there is a way to do a wild card with an asterisk but I can't get it to work.

BTW, for those of you who are wondering why I'm trying to do this, I need to find url's that are in directories that are banned in the robots.txt file.

Below is some code roughly the way it would need to be.

CODE

mysql_query("UPDATE table_name SET table_column = 'asdf' WHERE asdf2 = '$asdf2*'");

Oh, I checked out the php manual but I couldn't find anything on how to do it there.

Any help is appreciated...

[chrishirst]

'%' is a wildcard in SQL so

SQL

mysql_query("UPDATE table_name SET table_column = 'asdf' WHERE asdf2 LIKE '" . $asdf2 . "%'");