Ok, lessee...
SELECT user.user_id, user_name, user_history FROM user, history
WHERE user_history LIKE %58% AND user.user_id = history.user_id;
That should do what you need, lemme know.
Mike Hillyer
http://www.dynamergy.com/mike
-Original Message-
From: [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
I need a little help querying 2 tables in MySQL;
Table User
User_Id // Id = 2
User_Name // John
Table History
User_Id // 2
User_History // John has born in 58
SELECT User_History FROM History WHERE User_Id = 2; // return John has
born in 58
But what my SELECT
--- [EMAIL PROTECTED] wrote:
I need a little help querying 2 tables in MySQL;
Table User
User_Id // Id = 2
User_Name // John
Table History
User_Id // 2
User_History // John has born in 58
SELECT User_History FROM History WHERE User_Id = 2; // return John has
born in 58
But