Regular Expression

[Abdul Lateef Khan]

Hi All,

I have tow table having the following data

tab1
------------------------
ID | Number
------------------------
1 | 009198395555
2 | 009155442585
3 | 009777656252552
--------------------------------------

Tab2
-------------------------------------
Code | Name
-------------------------------------
91 | Inida
9198 | Inida Mobile
915544 | India Siddharth Nagar
977 | Nepal
-----------------------------------------

I want to display the tab1 Number data with their country name
Which alreay in Tab2 matching with Code from Number field of Tab1.

I tried with the following mySQL query but it show all Name which started 91. here is my query

SELECT * FROM Tab2 WHERE "^$NumOfTab1" REGEXP Code

if the $NumOfTab1 value is 009198395555 it should display only India Mobile but it is displaying all with is started from 91.

Can anyone help me how i can solve this?

Thank You