Env : My SQL 4.1.12-1 on Linux.

Let's say, I have two tables
1) user_details (username,ueraddress,userzipcode) all CHAR fields
2) zipcodelist (zipcode, cityname)

When a user enters his/her zipcode, I want to validate that this is a valid zipcode before inserting into the user_details table.
The web appl is in Jave (JSP).

What is the best way to implement this at the database side with this version of MySQL.

TIA

Sathyaram

MySQL 4.x does not support triggers or stored procedures, so you may want to try foreign keys. That would be my best guess.