Chayan - 1 year ago 60

SQL Question

We have a table which contains

`card_no`

`-----------------------------------------`

| id [int(11)] | card_no [varchar(16)] |

-----------------------------------------

| 1 | 0124578965874563 |

| 2 | 1245789658478596 |

| 3 | 8471452369587458 |

-----------------------------------------

Now we need a query to find card number(s) which contains

This is actually needed when we printed card numbers and find some numbers unreadable. so we need to identify the card with rest of the numbers. For example we have data like:

`1245_896584_8596`

Now we need to identify the card with this data.

Thanks in advance.

Answer Source