I'm searching for a query which search for te most match based on the search value '12345678'
The search value must be start from the first number.
My database has to colums
A |B
------------------------
1 |a
12 |b
123 |c
1234 |d
2345678 |e
What I want is the result of column B where the match is 1234. The result must be 'd' in this case
I hope someone can help me with this query.
The search value must be start from the first number.
My database has to colums
A |B
------------------------
1 |a
12 |b
123 |c
1234 |d
2345678 |e
What I want is the result of column B where the match is 1234. The result must be 'd' in this case
I hope someone can help me with this query.