Here is what I am doing now... SELECT id, first_name, last_name, password FROM account WHERE password = ENCODE("1234", 'foobar') ORDER BY last_name LIMIT 0,10
I need to do a where password LIKE '%1234%' instead, I can not seem to get this to work, is there some trick? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]