我的表格:
Mohammad
Ali
Moham mad
m Ohammad
Reza
Nasser
Mohamma d
我想从此表中选择 Mohammad 的所有名称甚至使用空间
喜欢:
select * from table where name like '%mohammad%'
// i want return Mohammad,Moham mad,m Ohammad,Mohamma d
也:
select * from table where name like '%Mohamma d%'
// i want return Mohammad,Moham mad,m Ohammad,Mohamma d
和:
select * from table where name like '%Moham mad%'
// i want return Mohammad,Moham mad,m Ohammad,Mohamma d
select * from table where REPLACE(name,' ','') like '%mohammad%'