我试图在我的sql数据库中按名称查询某一行,它有一个符号and.我试图设置一个转义字符,然后转义符号,但由于某种原因,这不起作用,我不确定我的问题到底是什么.
Set escape '\'
select * from V1144engine.T_nodes where node_id in(
select node2_id from V1144engine.T_edges where node1_id in(
select node2_id from V1144engine.T_edges where node1_id in(
select node2_id from V1144engine.T_edges where node1_id =
(select node_id from V1144engine.T_nodes where node_name = 'Geometric Vectors \& Matrices')))
and edge_type_id = 1)
and node_type_id = 1
and node_id in (
select node2_id from V1144engine.T_edges where node1_id =
(select node_id from V1144engine.T_nodes where node_name = 'Algebra II')
and edge_type_id = 2);
虽然这与this question的解决方案类似,但问题的提出方式却截然不同.他们可能最终得到相同的解决方案,但这并不意味着问题是相同的.