在SQLAlchemy中连接两个文本()语句

from sqlalchemy import func

concatenated_text = func.concat(text1, text2)

from sqlalchemy import create_engine, text, func

engine = create_engine('mysql+pymysql://username:password@localhost/db_name')

# 构建动态的查询语句
table_name = 'users'
column_name = 'name'
search_term = 'John'

query = text(f"SELECT * FROM {table_name} WHERE {func.concat(column_name, ' ') } LIKE :search_term")
result = engine.execute(query, search_term=f'%{search_term}%')

for row in result:
    print(row)

from sqlalchemy import create_engine, text, func

engine = create_engine('mysql+pymysql://username:password@localhost/db_name')

# 生成复杂的查询条件
column1 = 'name'
column2 = 'email'
search_term = 'John'

query = text(f"SELECT * FROM users WHERE {func.concat(column1, ' ', column2)} LIKE :search_term")
result = engine.execute(query, search_term=f'%{search_term}%')

for row in result:
    print(row)