Finding number in a string table mysql statement

Question

I have a table which is

table A

|noid    |
|ab123bs |
|a22a    |
|cc123cc |

I want to find '123' in that table

I have tried mysql:

SELECT * FROM table A WHERE '123' LIKE '%noid%' -not working

I also have tried mysql

SELECT * FROM table A WHERE '123' LIKE concat('%',noid,'%') -not working

you should find the column name: where 'noid' like '%123%' — waynelpu
– waynelpu, Commented Apr 12, 2019 at 1:42
thank you. I thought mysql only work when small string search in big string — user3487681
– user3487681, Commented Apr 12, 2019 at 2:04

wesin · Accepted Answer · 2019-04-12 01:43:36Z

1

select * from table A where nokp like '%123%';

answered Apr 12, 2019 at 1:43

wesin

263 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1