Search the Community
Showing results for tags 'sql help'.
Found 2 results
-
Hi and thanks in advance. Apologies but I'm a newbie at this. I've got a field in a MySql (Place_id) table called Pic. Most of the data in that field is in the form #1234 but some are in the format 1234. What I want to do is strip out the # part of the data in every record of that field in the table that contains it. Can anyone help me with the sql please. Thanks.
-
Hi ! I need help to for below described problem. I have three tables. Table 1 == Three fields == id, uid, mid Table 1 data records ========================================= id uid mid 1 0 1 2 1 0 3 2 0 4 0 1 Table 2 == Two fields == uid, uname Table 2 data records ========================================= uid uname 1 "username xyz" Table 3 == Two fields == mid, mname Table 3 data records ========================================= mid mname 1 "mgrname xyz" I want to fatch all the records of Table1, with the uname/mname from the Table 2 / Table 3. Can anybody help please.. Thanx !
