Question

mysql 语句如何合并where字符串

我的意思是select * from tb where name+'/'+age = ‘张三20’
name+age 是两个字段，如何实现？？

Answer 1

select * from tb where concat(name,age)='张三20'

Answer 2

没看懂什么意思

select * from tb where name='张三' and age='20';