How do you do this: SELECT * FROM table1 WHERE "table1.field1=0" --> SELECT * FROM table1 WHERE table1.field1=0
Is there a function in mysql that allows you to evaluate(dunno whether I use the correct term here) the string and not to treat it like a string? TIA. Ho Keat __________________________________________________ Do You Yahoo!? Yahoo! Kickin' Party - Win a 5-star getaway to exotic Bali! http://kickin.yahoo.com.sg --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php