[ Post New Message | Post Reply to this One | Send Private Email to Chad | Help ]

Response to Broken Things at MARP

from Chad (churritz@cts.com)
WOOHOO! I think i've found a solution to 1 and 2. Zwaxy, use "RLIKE" instead of "LIKE" when constructing the where clauses for the select statements, i think this is a pure regular expression search, instead of the psuedo one we're using (at least in the last python source you sent.) select * from games where long_name rlike '(pacman|pacmanm)';

I don't even think the slashes are necessary... but you should try some examples first. I'd imagine you'd want to use regular expression searching for all short game name searches, long name searches might still want to be psuedo regular expressions because you'd have to escape parathesis.

(posted 9026 days ago)

[ Previous | Next ]